Thanks. In the end I did something very similar, creating a custom page method with hardcoded SQL. It's not generic, but I only need it for one view.
On Mar 4, 12:57 pm, "Dardo Sordi Bogado" <[EMAIL PROTECTED]> wrote: > Try implementing Model::paginate() and Model::paginateCount(). > > On Tue, Mar 4, 2008 at 9:29 AM, leo <[EMAIL PROTECTED]> wrote: > > > I have two problems (that I wish to talk about): > > > 1. I need to paginate the results from a temporary table. > > > 2. I need to incorporate a "SELECT DISTINCT" clause into the paginator > > query. > > > Has anyone done either of these two or can anybody offer pointers as > > to what I should do? So far, I have created a model for the temporary > > table with a method that generates and executes the query. > > > I don't want to spend hours trying to achieve an impossibility if my > > time would be better spent coding around this. > > > Thanks, > > > Leo --~--~---------~--~----~------------~-------~--~----~ 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?hl=en -~----------~----~----~----~------~----~------~--~---
