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...@andreas-s.net> 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@googlegroups.com
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
