I needed to that a little while ago and got it to work with some  
slightly ugly hacking that probably doesn't scale too well, but it  
might work for you too. :)

This belongs in the controller:
http://bin.cakephp.org/view/1990384829

On 4 Nov 2008, at 13:20, mwcbrent wrote:

>
> I'm not sure that this is possible but if it is, it would put Cake
> into a special place in my heart.  I have 2 related models Articles
> and Ratings.
>
> Articles hasMany Ratings
>
> A Rating has a User ID an Article ID and a Rating #.  In order to get
> an articles rating I need to query all ratings by the Article ID and
> average them out.
>
> How would I paginate all Articles ordered by Rating?
> >


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