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


.

Relevant Pages