Probably:
$this->find('all', array(
'contain' => array(
'Department',
'Sale',
'Sale' => array('Shift(closed)')
),
'fields' => array('Log.cost'),
));
hth
On Oct 12, 9:50 pm, squidliberty <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
