| jonam 2004-03-28, 10:29 pm |
| All,
I have a weird problem w.r.t. DataTable Select.
My webservice calls a SQL2k stored proc that returns 3 resultsets. I
cache all the 3 resultsets so pages 2 onwards can be served off of
this cache. The second resultset contains an int column "counter".
The contents of this counter column are unique but not necessarily
incremented by 1. The counter column could have values viz. 1, 3, 4,
5, 8, 10, 12, 13, 14, ...
I use this "counter" column to set the DataTable.Select (sCriteria)
for pagination (say 100 rows per page).
Page sCriteria
1 counter >= 0
2 counter >= 123
3 counter >= 234
In my test scenario, I came across the weird behavior. The sCriteria
works for pages 1 and 2. For page 3, it brings back rows where
counter = 26 and counter = 27.
Am I missing something here?
Thanx in advance!
-j-
|