In this case just use plain SQL in paginate() and paginateCount().
On Aug 31, 9:52 pm, Dean C <[email protected]> wrote:
> Hi folks,
>
> I can't use a View for the union query as it requires parameters. Even
> if I take away the fulltext, and then do a fulltext search on the
> view, MySQL can't then delegate the indexes across the union within
> the view, so it doesn't work. Any more ideas or sample pieces of code
> would be appreciated :)
>
> Dean
>
> On Aug 28, 9:09 am, "Dr. Loboto" <[email protected]> wrote:
>
>
>
> > 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 <[email protected]> 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 [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
-~----------~----~----~----~------~----~------~--~---
