and don't forget to add to reviews model: belongs_to :product, :counter_cache => true
On Mar 13, 11:51 pm, Tom Z Meinlschmidt <[email protected]> wrote: > easiest and fastest way is to keep number of reviews in column in > product table... then simple add :order => 'reviews_count desc' in your > Product.find() > > tom > > > > Robert Scott wrote: > > Hi! I hope someone can offer some insight or direction into a problem > > I'm having. > > > In my application, I have two tables: products and reviews. > > > - Products stores information on things that are sold > > - Reviews store comments from users that purchased the product, as well > > as boolean field about if they would purchase again. > > > The models are setup so that products has_many reviews and reviews > > belong_to their respective products. > > > So my question is this: > > How can I structure a query so that I can order products based on the > > number of people who would purchase it again? > > > It'd be alot easier for me, and probably my server, if I just kept a > > running count of those in the actual product record, but I'm trying to > > keep it dynamic so that I can create custom reviewer sets elsewhere. > > > Thanks in advance for any direction. > > -- > =============================================================================== > Tomas Meinlschmidt, MS {MCT, MCP+I, MCSE, AER}, NetApp Filer/NetCache > > www.meinlschmidt.com www.maxwellrender.cz www.lightgems.cz > =============================================================================== --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
