I am trying to create a top 10 list for my website but I'm having some
trouble getting my find query to work. Currently I have something
like:

$top = $this->Model->find('all',array('order'=>"AVG
(Rating.score)","limit"=>10));

When I do this however I'm getting the following error:

Unknown column 'Rating.score' in 'order clause'

Any ideas on how to fix this or a better approach to use? Thanks



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

Reply via email to