I''m not an expert, but:
Try finding the User.friends instead of passing conditions manually.
@users = User.friends.find(:all)
I''ve never used the ":through" like you did with
"friendships"
If the code above doesn''t work try this:
{I guess this is the syntax based on the "through relationship")
@users = User.friendships.friends.find(:all)
You can do some edit in the route file, and see waht you want by
accessing this URLs:
(doesn''t need controller stuff)
example.com/users/3/friends
or
example.com/users/3/frienships/friends (again, I don''t know about the
":through" thing)
The code should be:
map.resources :users, :has_many => :friends, :through => :friendships
or just, I don''t know:
map.resources :users, :has_many => :friends
Thanks
On 15 jan, 02:25, Clem Rock
<rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org>
wrote:> This seems so easy but I keep hitting a brick wall on this.
>
> I have this modeling:
>
> [code]
> 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
> [/code]
>
> I have these 2 records in the friends table
>
> user_id, friend_id
> 3 4
> 3 5
>
> 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!
>
> Clem
> --
> Posted viahttp://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
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
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---