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