Hi Have you come across this article http://cakebaker.42dh.com/2007/10/17/pagination-of-data-from-a-habtm-relationship/ ?
I think the approach outlined in it might be worth looking at, in essence just build all your relationships inside paginate, as if it were just a bit of SQL... On Mar 30, 2:38 am, timtrice <[email protected]> wrote: > I have the following Find query to retrieve search results from my DB: > > $this->set( > 'results', > $this->Feed->FeedContent->find( > 'all', > array( > 'conditions' => 'MATCH( name, > keywords, description, encoded ) > AGAINST ( \'' . $keyword . '\')', > 'fields' => '*, MATCH( name, > keywords, description, encoded ) > AGAINST( \'' . $keyword . '\' ) AS score ' > ) > ) > ); > > I'd like to paginate the results but I absolutely cannot find a way > without generating errors. I can't alter my paginate array I > immediately declared in my Controller because that array is also > controlling other actions I have set up perfectly. I also do not want > to throw this code into another model as I see it as way too much > hassle to relate that Controller to the ones I have set up now. > > Does anyone know about where I can find what I need to get this query > paginated? I hate to have to write additional coding to do what > hoepfully will be easier than it seems with Cake. > > Thanks --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
