I've seen similar questions raised but haven't found a solution that works. Perhaps it's because I'm new to CakePHP and don't fully understand unbindModel(), bindModel(), container behaviors, etc. Anyway, I'll start simple and take suggestions.
I have the following models in which a Menu hasAndBelongsToMany Entree and hasMany MenuPosting, and a MenuPosting belongsTo Menu: class Menu extends AppModel { var $name = 'Menu'; var $hasAndBelongsToMany = 'Entree'; var $hasMany = array( 'MenuPosting' => array( 'dependent' => true ) ); } class MenuPosting extends AppModel { var $name = 'MenuPosting'; var $belongsTo = 'Menu'; } class Entree extends AppModel { var $name = 'Entree'; } In my MenusController I have a display_current() action to find all menus that are currently posted: class MenusController extends AppController { var $name = 'Menus'; function display_current() { // Limit the query results to the menu that is visible (i.e. is // currently posted) $conditions = array( 'MenuPosting.post_start <=' => date('Y-m-d H:i:s', strtotime ("now")), 'MenuPosting.post_end >' => date('Y-m-d H:i:s', strtotime("now")), ); // Find the menus that meets the conditions. $this->set('menu', $this->Menu->find('all', array('conditions' => $conditions))); } } The error I get from this is: Warning (512): SQL Error: 1054: Unknown column 'MenuPosting.post_start' in 'where clause' $sql = "SELECT `Menu`.`id`, `Menu`.`old_id`, `Menu`.`created`, `Menu`.`modified`, `Menu`.`title` FROM `menus` AS `Menu` WHERE `MenuPosting`.`post_start` <= '2008-12-06 22:02:57' AND `MenuPosting`.`post_end` > '2008-12-06 22:02:57' " If I remove the conditions from the find I am able to retrieve all Menu and associated Entree, so I believe I have set up my database tables correctly. Any suggestions? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---