Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

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

maria.dahlin@modul1.se
maria.dahlin@modul1.se
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.