If you can do view for your union query you will be able to work with it as with normal table.
On Aug 28, 5:58 am, Dean C <dean.clatwor...@gmail.com> wrote: > Hi folks, > > Before I begin, yes I've read this > page:http://book.cakephp.org/view/249/Custom-Query-Pagination > > I've also read many of the other pages on Google but I'm still stuck! > > First of all if I may introduce you to my > query:http://bin.cakephp.org/view/1064020598 > > It's a union query that allows me to search across two tables and > return the results, ordered by relevance. To put it simply I want to > paginate these results, but I haven't a clue how to do it. I tried, > and failed, over-riding the paginate and paginateCount methods in my > model, but I shan't even begin to post my long list of errors. > > Where should I start? > > Thanks! > > Dean --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
