Results 1 to 2 of 2
Jan 14, 2009, 21:27 #1
- Join Date
- Jul 2004
- 0 Post(s)
- 0 Thread(s)
Problems w/ User having many friends
This seems so easy but I keep hitting a brick wall on this.
I have this modeling:
class User < ActiveRecord::Base has_many :friendships has_many :friends, :through => :friendships #... end class Friendship < ActiveRecord::Base belongs_to :user belongs_to :friend, :class_name => 'User', :foreign_key => 'friend_id' end
Now when I try to select all friends that belong to User of id 3, using this select I get one record instead of 2:
@users = User.find:all, :include=>[:friendships], :conditions=>["friendships.user_id=?",3])
Any ideas how I can model this and query this correctly to get both records belonging to User 3?
Thanks a whole lot!