Have you checked out the section of the book on custom query pagination? http://book.cakephp.org/view/1237/Custom-Query-Pagination
<http://book.cakephp.org/view/1237/Custom-Query-Pagination>Even though in the end I ended up not using it .... I was able to paginate a custom query working from the examples in the book. - Ed On Sat, Jun 12, 2010 at 5:53 PM, Lucca Mordente <[email protected]>wrote: > Anybody? > > On 10 jun, 16:34, Lucca Mordente <[email protected]> wrote: > > Hello there > > > > I have a Search model which uses no database table that makes a > > fulltext search in some tables using plain SQL. > > > > How can I paginate the results of a $this->query($plainSQL) call ? > > > > Precisely, how do I implement the paginate() method using query() > > instead of find() ? > > > > Thanks! > > Check out the new CakePHP Questions site http://cakeqs.org and help others > with their CakePHP related questions. > > 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]<cake-php%[email protected]>For > more options, visit this group at > http://groups.google.com/group/cake-php?hl=en > Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
