Nah, $page was getting passed ... I tracked it all the way into the db libraries and realized the problem:
I'm using SQL Server, which doesn't use OFFSET and has no real equivalent function. The dbo_mssql library translates the request as TOP, which returns the first 10, 20 or whatever. I guess pagination with MS SQL is challenging no matter what platform you're developing, as the workaraounds were easy to find, but they are all (seemingly) more complex than they need to be. Isn't there a way to do it with an array or something? On Oct 17, 4:49 pm, "AD7six" <[EMAIL PROTECTED]> wrote: > You are probably not passing the var $page to your find > > list($order,$limit,$page) = $this->Pagination->init(); > $this->data = $this->Course->findAll(null, null, $order, $limit, > $page); > > HTH, > > AD7six --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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/cake-php -~----------~----~----~----~------~----~------~--~---
