ok, I didn't search the group properly. The thing I'm requesting seems not to be supported, what people seem to do instead and which I ended up doing was adding a third class for association. Meaning instead of having two models with HABTM. I now have two Models with hasMany (originally HABTM) and the third ''new'' class with belongsTo associations.
By creating the join model one other thing is achieved, extra fields (the ones apart from the ones associating the two tabels) can now be accessed. Nate on model setup: http://groups.google.com/group/cake-php/browse_thread/thread/bef70558f7854732/6363603e04fcee68?lnk=st&q=&rnum=10#6363603e04fcee68 On Jul 24, 10:23 pm, safl <[EMAIL PROTECTED]> wrote: > Hey, > > The case is: > I've got 2 models(Customer and Server), one is using $useDbConfig = > 'crm' the other is using $useDbConfig = 'monitoring'. > Each DB configuration specifies connection to it's own database (crm > and monitoring). > > I've got HABTM between these to models, and I need HABTM, but when > querying i get "Table doesn't exist" since the join table only lives > in one of the databases. All other associations seems to work across > databases. > > My question is: > > How can I in the "$hasAndBelongsToMany" definition specify that the > join table is living in a different database? > > regards, > Simon --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
