Don't miss out Virtual Happy Hour this Friday (April 26).

Try our conversational search powered by Generative AI!

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
Michael Luke
Michael Luke
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.