Re: [PHP-DB] 2-Table query
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" [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] 2-Table query
Whups, that should be a backslash. \; Regards, Andrew On 4/15/01 8:05 PM, "Andrew Hill" [EMAIL PROTECTED] 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" [EMAIL PROTECTED] 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] 2-Table query
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