Hi,

i would like to make a join over two databases.

In plain mySQL that is easy like

"... from a.user LEFT JOIN b.countries ..."

where a and b are on the same host.


I tried to do the same thing in cake by defining in the country model

var $useTable = 'b.countries';

but it always comes up with an error. Does anybody know how i can use
the cakes database abstraction but still make cross database joins.
Rewriting all the queries in the model like save is not really a nice
option.

Cheers

Phil


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to