#5675: Pagination is not working on MSSQL
---------------------------------+------------------------------------------
Reporter: braulio | Type: Bug
Status: new | Priority: Medium
Milestone: 1.2.x.x | Component: MSSQL
Version: RC3 | Severity: Normal
Keywords: mssql,pagination | Php_version: PHP 5
Cake_version: 1.2.0.7692 RC3 |
---------------------------------+------------------------------------------
I am having troubles with pagination, because when I go to the next
page or any other, the browser always reloads the same page in all
of the actions where I use it.[[BR]]
[[BR]]
I have Configure::write('debug', 2) and I am seeing that the SQL
queries generated are wrong (there is no ORDER BY -on the first load-).
They should be like here: [http://josephlindsay.com/archives/2005/05/27
/paging-results-in-ms-sql-server/]. Also, the last page always display
the maximum rows per page.[[BR]]
[[BR]]
In SQL Server 2005 and above something like this link would work:
[http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx]. Maybe
the code could detect if it is working on an SQL Server 2005 and above...
--
Ticket URL: <https://trac.cakephp.org/ticket/5675>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
