After reading again the post
$this->find('all', array(
'contain' => array(
'Department', 'Sale' => 'Shift(closed)'),
'fields' => array('Log.cost')
),
);
Hope this works, I did not catch all relations at first glance, you
might also use the containable behaviors in the Sale / Departement
model ..
On Oct 12, 11:02 pm, squidliberty <[EMAIL PROTECTED]> wrote:
> Thanks for the speedy response! Unfortunately, that doesn't return any
> data from the Shift model. I guess 'fields' overrides 'contain'?
> - Scott
>
> On Oct 12, 4:20 pm, francky06l <[EMAIL PROTECTED]> wrote:
>
> > 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
-~----------~----~----~----~------~----~------~--~---
