Is there any reason why you wouldn't use Cake's Built in model relationships. Defining a hasOne or hasMany relationship in the Model should do the trick.
On May 17, 4:25 am, floepi <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
