London Dev Meetup Rescheduled! Due to unavoidable reasons, the event has been moved to 21st May. Speakers remain the same—any changes will be communicated. Seats are limited—register here to secure your spot!

Problem with Data Provider SQL in EPiFields - skips first row in results

Vote:
 
I've been testing EPiServer 4.40 and EPiFields. When using the Data Provider SQL, and writing SQL statements in the file EPiServerFieldsSQL.config, I noticed that the first row of the results was not returned. For example, writing SELECT * from a table that has 4 rows will only return rows 2-4. Has anyone had a similar problem?
#12204
Jan 27, 2005 16:39
Vote:
 
That is correct, it is a bug in the file \WebRoot\EPiServer.Fields\Integration\DataProviderSQL.cs located in the base samples. To correct this bug change the line 105 from: for(int i = 1; i < inTable.Rows.Count ; i++) to for(int i = 0; i < inTable.Rows.Count ; i++) and rebuild your base sample assembly. (This will be corrected in the next version of EPiFields)
#13832
Jan 28, 2005 14:44
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.