On 10/28/07, John Siracusa <[EMAIL PROTECTED]> wrote: > On 10/28/07 9:03 PM, Arshavir Grigorian wrote: > > I have a many-to-many relationship. When I insert a new record in the > > mapping table, while also inserting a new record one of the end > > tables, I would like to set a certain value in the mapping table. > > Many-to-many relationships exist as a convenient way to ignore the "middle" > (mapping) table and get right to the "leaf" table. Once you want to > manually alter the mapping table, what you're really looking at is two > separate relationships: a one-to-many to the mapping class followed by a > many-to-one relationship in the mapping class itself to the "leaf" class. > > This thread discusses a few other possibilities: > > http://www.mail-archive.com/rose-db-object@lists.sourceforge.net/msg01329.ht > ml >
Thanks. > > Also, I am using t2s() to add the mapping for $t2_id, but the mapping > > record for $t1 are not deleted first before the new one is added. > > Are you using an "add" method or setting the whole list using a > "get_set_on_save" method? > > -John I am using the syntax that you used in the docs : $p = Product->new(id => 123)->load; $p->colors({ name => 'pink' }, { name => 'orange' }); # Delete old rows in the mapping table and create new ones $p->save; I am definitely not using the add_colors() method. Not sure if get_set_on_save() is called in the background. Arsh ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object