RE: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)


Hi Ron,

Yes, thanks. I have it working now. Now I am working on the UPDATE
from a SELECT. I am having problem with char columns. I am working on
a routine that will identify the columns that require quotes and
dynamically plug them in before doing the update.

Thanks for all your help.

Peter Loo
Wolters Kluwer Health
(602) 381-9553

-----Original Message-----
From: Ron Savage [mailto:ron@xxxxxxxxxxxxx]
Sent: Thursday, April 20, 2006 4:14 PM
To: List - DBI users
Subject: RE: Bad int8 external representation "" (SQL-HY000)(DBD:
st_execute/SQLExecute err=-1)

On Thu, 20 Apr 2006 07:51:24 -0700, Loo, Peter # PHX wrote:

Hi Peter

Do you mean plug in the work "undef" before doing the INSERT?

Yes. Off the top of my head (add error checks!):

$sql = 'insert into table_x (column_y, column_z) values (?, 99)'; $sth =
$dbh -> prepare($sql); $sth -> execute(undef);
--
Cheers
Ron Savage, ron@xxxxxxxxxxxxx on 21/04/2006
http://savage.net.au/index.html Let the record show: Microsoft is not an
Australian company




This E-mail message is for the sole use of the intended recipient(s) and
may contain confidential and privileged information. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the intended recipient, please contact the sender by reply E-mail, and
destroy all copies of the original message.


This E-mail message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply E-mail, and destroy all copies of the original message.
.