develooper Front page | perl.dbi.users | Postings from April 2006

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

Thread Previous | Thread Next
From:
Loo, Peter # PHX
Date:
April 20, 2006 16:22
Subject:
RE: Bad int8 external representation "" (SQL-HY000)(DBD: st_execute/SQLExecute err=-1)
Message ID:
8E3D502A002DA04FADBDED4CB4D94D3A01259E5F@phxmail02.phx.ndchealth.com

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@savage.net.au] 
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@savage.net.au 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.

Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About