Pagination not working

[eluser]bhakti.thakkar[/eluser]
Hi Steve,
The problem is there is no limit and offset clause in MSSQL DB. So even if you specify limit and offset, things are not goin to work. Well, right now , i am using the mechanism i have provided in my previous thread and things are working fine :-) the only problem i am facing is, if suppose there are 19 records and i want 15 records per page, then what happens is on first page 15 records are displayed well but on click of next it shows me again 15 i.e new 4 and previous pages 11 records. it shud be only 4 on the next page logically. but that fine until i find some alternative for it. i have scanned to numerous forums of CI and total scan search in this forum as well, but no solution so far.

If i could help you out in any way just let me know!!! :coolsmile: