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:[EMAIL PROTECTED] 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, [EMAIL PROTECTED] 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.