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