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]

Reply via email to