Thanks for the reply. That's all well and good if I'm going from a certain offset, but if I want the whole shebang I wouldn't even need an offset or a limit. I'm speaking more specifically to the 'limit' option in the Pagination helper. Although, I suppose I could try Custom Query Pagination.
On Sep 17, 7:04 pm, Joel Perras <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
