RE: Join Tables between db

I have made join_table models for ones that did not have any and set the db
to use for the join_models that I had existing, but no matter what even
when specified to use

var $useDbConfig = 'default';

or

var $useDbConfig = 'resources'; it will not find the table.

Cleared cache. Both $useDbConfig are set correct as they work for other
models.

!! WEIRD THING !!

I noticed that by default leaving the model untouched with no var
$useDbConfig as long as the join_table is in the same db as the first name
of the join it works fine.

Example: categories_posts (categories is in resources db, posts is in
default db) as long as I place categories_posts in same db as categories all
is fine. Move it to default where I want it and I get missing table. Since
convention prevents me from renaming the table (C befoe P alphabetically)
whats wrong here?

Anyone come across this?

Suggestions?

Thanks,

Dave

From: Dave Maharaj [mailto:me@davemaharaj.com]
Sent: Tuesday, January 25, 2011 9:39 PM
To: cake-php@googlegroups.com
Subject: Join Tables between db

I have a site with 2 databases (same server)
1. Being resources_db (data that never changes, Country, States, various
selects and options to select from throughout the site)
2. default_db users, profiles, things that can be changed, edited by users.

Now join tables happen to cross between resources_db and default_db where
does the join tables go in these situations? How do you tell Cake where to
look?

Thanks,

Dave
--
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+unsubscribe@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+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php