Grant Cox wrote:
> 1. It is just not possible to do this, unless the one mysql
> connection has permission to access both databases (ie same database
> server, same user/pass).
unfortunately in this case they are seperate databases with seperate
permissions, although they are within the same mysql server (although for
future
projects this might not be true either)
i've just replaced the code with some manual stuff, query the users db, then
loop, query and merge the results from the documents db.
But, I can see this becoming more of an issue as Cake becomes more widely used
and people try to integrate their apps with existing databases. The ability to
$useDbConfig is great and works perfectly until you start doing cross-db
conditions. Of course it would be fantastic if the code didnt have to know or
care about the database backing the model, that way it would be much more
portable.
Im sure generalising the problem for dealing with all possible queries across
multiple seperate databases (and merging the results) is very difficult, so I
dont expect this feature to be added anytime soon, but if anyone has seen this
capability in any other framework I would be interested in seeing how its done
(and trying to port it to Cake)
thanks everyone for your help.
Martin
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
