except the sentence
starting with NEVER, NEVER Will you kindly explain?
Thanks again.
Peter
-Original Message-
From: Alexander Foken [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 08, 2007 2:11 PM
To: Loo, Peter # PHX
Cc: dbi-users@perl.org
Subject: Re: Trapping error for $dbh-do
Hi,
I am trying to execute multi SQL statements within the $dbh-do() and it
appears to work fine except it does not give me an error when part of
the SQL fails. For example:
BEGIN WORK;
CREATE TEMP TABLE p_temp AS
SELECT col1
, col2
, col3
FROM table1
, table2
WHERE
Quoting the DBI man page
http://search.cpan.org/~timb/DBI-1.55/DBI.pm#Database_Handle_Methods:
do
$rows = $dbh-do($statement) or die $dbh-errstr;
$rows = $dbh-do($statement, \%attr) or die $dbh-errstr;
$rows = $dbh-do($statement, \%attr, @bind_values) or die ...
Prepare and
# PHX
Cc: dbi-users@perl.org
Subject: Re: Trapping error for $dbh-do()
Quoting the DBI man page
http://search.cpan.org/~timb/DBI-1.55/DBI.pm#Database_Handle_Methods:
do
$rows = $dbh-do($statement) or die $dbh-errstr;
$rows = $dbh-do($statement, \%attr) or die $dbh-errstr;
$rows
and destroy the original
message without making a copy. Thank you.
- Original Message -
From: Loo, Peter # PHX [EMAIL PROTECTED]
To: Alexander Foken [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Sent: Tuesday, May 08, 2007 5:44 PM
Subject: RE: Trapping error for $dbh-do()
Hi Alexander,
Thanks