Thanks a lot for such a detailed answer! I finally made it work:
$this->paginate['Instrument'] = array('contain' => array('Group' =>
array('Sector')));
$instruments = $this->paginate('Instrument');
$this->set('instruments', $this->paginate());On Feb 7, 2:48 pm, WebbedIT <[email protected]> wrote: > If you just want to fetch and display the name then you can use > 'containable' which allows you to specify exactly which models you > want to fetch data from. > > Add var $actsAs = array('Containable'); to /app/app_model.php (as you > pogress with cake you are likely to need this behaviour in all models) > then you can do more instructive finds like this: > > $this->data = $this->Referral->find('first', array( > 'conditions' => array('Referral.id'=>$id), > 'contain' => array( > 'AgencyContact' => array( > 'Person'=>array > ('OnlineAddress','PostalAddress','TelephonyNumber'), > 'Agency'=>array('Organisation'=>array > ('OnlineAddress','PostalAddress','TelephonyNumber')) > ), > 'Bednight' => array('Household'=>array('Organisation')), > 'Client' => array( > 'Person'=>array('Ethnicity','Gender','Religion','Sexuality') > ), > 'Reason', > 'Scheme' => array('Organisation'), > 'Staff' => array('Person') > ) > ) > ); > > Your find would be something more simple like: > > $this->data = $this->Instruments->find('all', array( > 'contain' => array( > 'Group' => array('Person') > ) > ) > ); > > Once you run a find using containable I advise you echo the resulting > array to get used to the different format. Also containable does a > lot of seperate queries rather than one big query so it can limit > things like conditions on the Group or Sector table (I tend to only > use it for view type actions) > > If you need to add conditions on the related tables (Group or Sector) > then you will need to force a join. See the below for more > information: > > http://groups.google.com/group/cake-php/browse_thread/thread/7f5fceea... > > Paul. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
