Re: [RDBO] Adding data to the mapping table in many-to-many

2007-10-28 Thread John Siracusa
On 10/28/07 10:45 PM, Arshavir Grigorian wrote: > On 10/28/07, John Siracusa <[EMAIL PROTECTED]> wrote: >>> 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 th

Re: [RDBO] Adding data to the mapping table in many-to-many

2007-10-28 Thread Arshavir Grigorian
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

Re: [RDBO] Adding data to the mapping table in many-to-many

2007-10-28 Thread John Siracusa
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 conven

[RDBO] Adding data to the mapping table in many-to-many

2007-10-28 Thread Arshavir Grigorian
Hi, 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. t1_t2_map ( id, t1_key, t2_key, another_column ) I am using the following syntax: my $t