On Mon, Aug 24, 2009 at 6:24 PM, Allen
Walker<[email protected]> wrote:
>
> I have a User model and in I want to have a
>
> has_and_belongs_to_many :users
>
> Obviously that won't work since the join table will have the same column
> names (user_id).
>
> What approach should I take?

You need to give the association a different name, and a few other things

class User
   has_and_belongs_to_many :friends,
                                            :class => "User",
                                           :association_foreign_key =>
"friend_id",
                                           :join_table => "friends_users"
end


You then need to make a join table named "friends_users" with no
primary key and user_id and friend_id columns.

-- 
Rick DeNatale

Blog: http://talklikeaduck.denhaven2.com/
Twitter: http://twitter.com/RickDeNatale
WWR: http://www.workingwithrails.com/person/9021-rick-denatale
LinkedIn: http://www.linkedin.com/in/rickdenatale

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to