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

Ron Savage said:
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
Minior change: should it not be:
$sth -> execute((undef));


-------

William R. Mussatto, Senior Systems Engineer
http://www.csz.com
Ph. 909-920-9154 ext. 27
FAX. 909-608-7061

.

Relevant Pages