I tried both ways that you suggested. I'm still getting a undefined column for Rating.score
On Feb 17, 2:27 am, Kyle Decot <[email protected]> wrote: > It still doesn't seem to be working. After looking at the query it is > generating, it doesn't seem to be including any of my hasMany items. > Any thoughts? > > On Feb 17, 2:14 am, Miles J <[email protected]> wrote: > > > Well if your trying to get the score from the Skatepark model: > > > $this->Skatepark->find('all', array( > > 'order' => 'AVG(Rating.score)', > > 'limit' => 10, > > 'contain' => array('Rating') > > )); > > > You would need the containable behavior OR remove the contain and make > > the recursive higher. > > > $this->Skatepark->find('all', array( > > 'order' => 'AVG(Rating.score)', > > 'limit' => 10, > > 'recursive' => 1 > > )); --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
