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:m...@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+unsubscr...@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