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 [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
-~----------~----~----~----~------~----~------~--~---
