Rails - May 2008 - update on a m:n table

Hi all

following situation:
3 tables:
users (id, nickname,...)
conversations(id, ...)
conversations_users(user_id, conversation_id, date_deleted)

2: models
user (has_and_belongs_to_many   :conversations,
:join_table=>''conversations_users'',
:conditions=>''date_deleted IS NULL'')
conversation

How can i update update the "date_deleted" in the m:n join table? If i
want to do it by
user.conditions.date_deleted = DateTime.now

it don''t work


Any idea?

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

I dont like this way, but this is my answer :

for sample in user.conditions
   sample.date_deleted = DateTime.now
end

but it will hurt your AR or database because it will connect to database 
for each looping. Maybe another have lovely solution.

Reinhart
http://teapoci.blogspot.com
-- 
Posted via http://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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---