Re: 2-Table query

Whups, that should be a backslash. \; Regards, Andrew On 4/15/01 8:05 PM, "Andrew Hill" <ahill@openlinksw.com> wrote: > Randall, > > Try making $qryStr contain something like "insert into table1 (col1, col2) > values ($val1, $val2) /; insert into table2 (col1, col2) values ($val1, > $val2); > > Not sure if the slash is the proper escape - it should work. > > > Best regards, > Andrew > -------------------------------------------- > Andrew Hill . Director Technology Evangelism > OpenLink Software . www.openlinksw.com > Internet Data Integration Technology > > > > On 4/9/01 8:31 PM, "Randall Barber" <rdb55@email.byu.edu> wrote: > >> I would like to update two tables at the same time. >> >> Currently I update each one separately, like so, >> >> $qryStr = "INSERT INTO table1 etc...."; >> odbc_exec($dbConn, $qryStr); >> >> $qryStr = "INSERT INTO table2 etc...."; >> odbc_exec($dbConn, $qryStr); >> >> Now, the problem there is if the first one passes, but the second fails, if >> the user tries to re-submit, the first now fails because of a primary key >> clash which is right, but then never executes the second one. >> >> This is what I THINK I should do, >> >> $qryStr = "(INSERT INTO table1 ( col1, col2 ) VALUES ( '$val1', >> '$val2' ) ) >> AND (INSERT INTO table2 ( col1, col2 ) VALUES ( '$val1', '$val2' ) >> )"; >> odbc_exec($dbConn, $qryStr); >> >> Any ideas are appreciated... I am not experienced with SQL query precedences, >> or operators, etc... A good reference for that very thing would be nice. >> Thanks in advance, >> RDB >> >