I've seen variants of issues involving these topics posted, but not this particular one.
I use a master "_users" table and "_groups" table in my projects. A given project will have tablePrefix set to "projectname_" and all the tables specific to that project are correctly named "projectname_tablename". Unfortunately if I try to establish HABTM between "_users" and "_groups" or either of those tables and a table from a specific project, it gets ugly. My goal is to have my tables look like this: - _groups - _users - _groups_users (join table) - projectprefix_comments - projectprefix_comments_users (join table) - projectprefix_posts - projectprefix_posts_users (join table) - projectprefix_comments_posts (join table) I have currently resorted to specifying every single table in each model and removing any tablePrefix settings. I cannot specify a tablePrefix when defining the habtm relationship, and the useTable value is automatically appended by the project level tablePrefix, ignoring any Model level tablePrefix. Admittedly, sorting out which prefixes should automagically be used may be debatable, but I think I should have the ability to clear tablePrefix and set joinTable to explicitly point to any given table in my habtm definition. I hope that was clear. Does anyone have any clean fixes for this? Thanks in advance for any advice --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
