FYI, the MySQL docs actually recommend that to "retrieve all rows from a certain offset up to the end of the result set, you can use some large number for the second parameter". You can always wrap this up in a custom pagination function, which should achieve your desired result. If you want to get fancy, you could figure out an efficient method for obtaining the total number of records (through count caching, I suppose), and then use that as your upper limit.
MySQL quote cited above: http://dev.mysql.com/doc/refman/5.0/en/select.html -Joel. On Sep 17, 6:15 pm, Brenton B <[EMAIL PROTECTED]> wrote: > Hello. > I would like to make use of the sort functionality in the Paginator > class; however, don't want to actually paginate. > My options are to either strip out the Sort stuff and create a new > helper, or set the 'limit' in the options to something crazy high - > which I think is a bit of a hack. > I was hoping that the 'limit' option would take a value like 'all' and > just return all (obviously), but no such luck. > Anyone else have any other ideas? > Naturally, I could go with just passing args in the `find` function, > but just thought I'd check. > > Cheers --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
