I have three models: Shift, Sale and Log that are related using
CakePHP associations (see model definitions below). I want to find
logs and return their associated sale and the sale's associated shift.
But I'm having a hard time with this...
$this->find('all', array(
'contain' => array(
'Department',
'Sale',
'Sale' => array('Shift')
),
'fields' => array('Shift.closed', 'Log.cost'),
));
Any idea why this produces "SQL Error: 1054: Unknown column
'Shift.closed' in 'field list'? Where am I going wring? Any advice
would be appreciated! I've also tried using recursive instead of
contain, but had similar results.
Models:
class Log extends AppModel {
var $name = 'Log';
var $belongsTo = array('Department', 'Sale');
var $actsAs = array('Containable');
}
...
class Sale extends AppModel {
var $name = 'Sale';
var $belongsTo = array('Shift');
var $hasMany = array('Log');
}
...
class Shift extends AppModel {
var $name = 'Shift';
var $hasMany = array('Sale');
}
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
