RE: Multiple statements within one $dbh-do()

2007-08-15 Thread Loo, Peter # PHX
statements within one $dbh-do() Loo, Peter # PHX wrote: Hi, I am trying to execute two SQL statements within one call to $dbh-do() and Perl DBI is not happy. Here is a sample call: $sql = qq{delete from some_table where condition_one andcondition_two

RE: Multiple statements within one $dbh-do()

2007-08-14 Thread Garrett, Philip \(MAN-Corporate\)
Loo, Peter # PHX wrote: Hi, I am trying to execute two SQL statements within one call to $dbh-do() and Perl DBI is not happy. Here is a sample call: $sql = qq{delete from some_table where condition_one andcondition_two; insert into some_table