Rails - Sep 2006 - ActiveRecord foreign keys

Hi all,

I have a small problem with ActiveRecord and I was wondering if anyone can
help me.
I have 2 tables: users and activities and inside activities I have a foreign
key (user_id) to the user table. Everything is ok.

I want now to add another foreign key to users, called added_by_user_id.
I''ve changed the model to Activity:
belongs_to :user, :foreign_key => ''user_id''
belongs_to :user, :foreign_key => ''added_by_user_id''

but now activity.user is not defined anymore.

I was wondering if there is any way to ''map'' the users in
different
attributes of activity. I''ve checked the  API but couldn''t
find anything.

Any help is much appreciated.

Cheers,
Paul


--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---

Hi Paul

belongs_to :user, :foreign_key =>
''user_id''
> belongs_to :user, :foreign_key => ''added_by_user_id''

the first parameter (:user) has to be different for the second user
reference otherwise it conflicts with the first declaration (you can use
something like "user_who_added_it" - but you''ll want to find
a better name
:-)

this should work:

belongs_to :user
belongs_to :added_by_user, :class_name => ''User'',
:foreign_key =>
''added_by_user_id''

Then you''ll have access to the use who added through
mymodel.added_by_user

cheers

Thibaut
--
[blog] http://www.dotnetguru2.org/tbarrere


--~--~---------~--~----~------------~-------~--~----~
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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk
-~----------~----~----~----~------~----~------~--~---