Phlip wrote:
> Grayson Piercee wrote:
>
>> User.find(:all, :conditions => ["interests in
>> (?)",current_user.interests)
>
> Here's a wild guess. I hope someone else corrects it if I have lead you
> astray!
such as...
User.find(:all, :include => :interests,
:conditions => [ "interests.id IN (?)",
current_user.interests.map(&:id) ]
:order => 'COUNT(interests.id) DESC')
and use inspect_sql to see the query it generates!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
