+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived Development & Programming (https://forum.codeigniter.com/forumdisplay.php?fid=23)
+--- Thread: Pagination doesn't work in mssql, help please :( (/showthread.php?tid=15912)
Pagination doesn't work in mssql, help please :( - El Forum - 02-18-2009
[eluser]Silencez[/eluser]
Hello.. I've being looking for a solution to the pagination mssql problem, and I found at least two, but I'm not sure if they really work and what it's the best
Someone with more experience can give me a hand with that?
Thank you
Pagination doesn't work in mssql, help please :( - El Forum - 02-18-2009
[eluser]majidmx[/eluser]
Just want to clarify something for myself ...
is it a pagination problem ? or a MS-SQL problem ? or "pagination mssql problem" which I need more info about the latest one
Pagination doesn't work in mssql, help please :( - El Forum - 02-18-2009
[eluser]Silencez[/eluser]
OMG!!
In mssql pagination doesn't work, I try the basic limit() function but it increases the amount of results instead of giving me the second, thrid, etc page...
I am not the first one with this problem that's why I thought there was no need for more details:
http://ellislab.com/forums/viewthread/62803/
I'd like a good active record hack, I dont know if anyone has something new and more effective to solvent this problem
Thank you
Pagination doesn't work in mssql, help please :( - El Forum - 02-19-2009
[eluser]majidmx[/eluser]
Even if you do manual queries , will you get the same result ?
Pagination doesn't work in mssql, help please :( - El Forum - 02-19-2009
[eluser]Silencez[/eluser]
I have not tested it yet, but one of the fw aproach is to write standard code that works with several sql engines, no?
It have no sense write manual sql if they are simple queries...
Pagination doesn't work in mssql, help please :( - El Forum - 02-19-2009
[eluser]majidmx[/eluser]
Well I prefer the manual ones as long as I'm going to stick with my DB engine.
Because specially for the high load traffics I think Active Record takes a lot of resources.