Re: [GENERAL] [PERL DBI] Insertiing data across multiple tables

2008-07-24 Thread Klint Gore
JD Wong wrote: Does anybody know how to insert data over multiple tables transactionally? The relationship is 1:1 with the latter table having a foreign key constraint. In order to add data to Table2 I need to know the primary key value of the same record in Table1 before it's committed, whi

Re: [GENERAL] [PERL DBI] Insertiing data across multiple tables

2008-07-24 Thread SCassidy
[EMAIL PROTECTED] wrote on 07/24/2008 01:36:27 PM: > Does anybody know how to insert data over multiple tables > transactionally? The relationship is 1:1 with the latter table > having a foreign key constraint. In order to add data to Table2 I > need to know the primary key value of the same

[GENERAL] [PERL DBI] Insertiing data across multiple tables

2008-07-24 Thread JD Wong
Does anybody know how to insert data over multiple tables transactionally? The relationship is 1:1 with the latter table having a foreign key constraint. In order to add data to Table2 I need to know the primary key value of the same record in Table1 before it's committed, which in this case is a