Well, looks like the solution is: override the findAll function in the model, to give the paginator what I want it to have, not what cake wants it to have :)
I'll see how I get on tomorrow, but I suspect it will work exactly as the theory suggests. Mike On 13/09/2007, Mike Green <[EMAIL PROTECTED]> wrote: > > If you can pass a custom query to the paginator, then yes that would > work fine, but I'm not using $this->Model-> anything, I'm only using > > $this->paginate > > Mike > > > On Sep 13, 5:13 pm, fr3nch13 <[EMAIL PROTECTED]> wrote: > > You can use $this->Model->query(); > > However, it won't return any dependent models with it. > > > > http://manual.cakephp.org/chapter/models > > > > On Sep 13, 12:03 pm, Mike Green <[EMAIL PROTECTED]> wrote: > > > > > Hi folks > > > > > I want to query two tables at the same time, mysql lets me do this > > > with: > > > > > SELECT name,age FROM football > > > UNION > > > SELECT name,age FROM baseball > > > > > which will produce something like this: > > > > > name age > > > John 20 > > > Alex 21 > > > Robort 23 > > > Reid 16 > > > Greek 19 > > > > > ( shamelessly stolen > > > fromhttp://www.plus2net.com/sql_tutorial/sql_union.php > > > - linked to get a better idea of what im trying to achieve ) > > > > > I have two tables, each identical schema, but with data from different > > > places. I need to either create something that will override the > > > default "findall" function, or do something clever with the paginator > > > as the results *must* be shoved through the paginator. > > > > > I'm not fussy about the overhead, if it takes 10 minutes to return the > > > results, then thats fine. > > > > > At the moment, I perform two queries, one on model1 and one on model2, > > > and then join the results with some php array management, then shove > > > that through my view, although obviously this doesnt make use of the > > > great cake 1.2 paginator.. > > > > > all and any ideas appreciated. > > > > > Mike > > > > > -- ------------------------------------ Mike Green Find yourself some misspelled ebay bargains! http://www.typingwand.com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
