What is your recursive parameter set to? And have you considered using Containable behaviour? See http://book.cakephp.org/view/474/Containable
Enjoy, John On May 5, 4:54 pm, Greg Skerman <[email protected]> wrote: > Hey guys, > > Struggling to figure out why this wont work (cake 1.2). > > $this->set('Characters', > $this->User->Account->Character->find('list', array( > 'conditions' => array( > 'User.id' => $this->Auth->User('id') > ) > ) > ) > ); > > What am I doing wrong here? the generated query statement is obviously wrong > - its not building the joins. > > *Query:* SELECT `Character`.`id`, `Character`.`name` FROM `characters` > AS `Character` WHERE `User`.`id` = 1 > > belongsTo and hasMany is right throughout and generated via bake. Doing a > search on Account conditioning by user works. And doing a search on > character conditioning by Account works, but as soon as i step more than one > level down it stops generating the joins. > > Help??? > > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others with > their CakePHP related questions. > > 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 > athttp://groups.google.com/group/cake-php?hl=en Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
