|
hello, im using R:Tango and using some info i found
from a post i made a couple months ago, i was able to page my results by
limiting count to > ((page-1)*100) and <= (page*100).
Thats working great, just like it should be, but my
problem comes in when i add an order by clause. lets say i had 1000
results, each with a unique id from 0-1000 and they were inserted into the
databse ireegularly (50, 900, 12, 345...). If i order by id, i was hoping
that i would get something like the first page was 1-100, second page was 101 to
200 etc. What im getting instead is 100 random values, but they are sorted
corectly (first values on first page could be like ... 30, 32, 40, 48, 60,
72...).
Is there a good way to do what im trying to
do?
Thanks!
Atrix |
