Actually it seems to be working with a view. No need for a synonym. As long as the user you're
connected with
has granted rights on the tables you're guerying of course :)
Sorry for not trying with a view earlier !
G.
Selon Zaky Katalan-Ezra:
Did you try to create a view for the synoname?
On Mon, Mar 7, 2011 at 9:53 PM, guix69 <g...@realguix.com
<mailto:g...@realguix.com>> wrote:
Database is the same, only the schema is different.
My database.php contains the settings to connect to SCHEMA1 but I
would like to make a model to query data from SCHEMA2
I tried using a synonym (inside SCHEMA1, pointing to the desired table
inside SCHEMA2) but it looks like the synonym is invisible to cake.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org <http://tv.cakephp.org/>
Check out the new CakePHP Questions site http://ask.cakephp.org
<http://ask.cakephp.org/> and help others with their CakePHP related
questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
<mailto:cake-php%2bunsubscr...@googlegroups.com> For more options,
visit this group at http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php