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

On Thu, 20 Apr 2006 16:33:14 -0700 (PDT), William R. Mussatto wrote:

Hi William

$sql = 'insert into table_x (column_y, column_z) values (?, 99)';
$sth = $dbh -> prepare($sql); $sth -> execute(undef); -- Cheers

Minior change: should it not be:
$sth -> execute((undef));

Well, no. Firstly I believe the original code is correct, and secondly that
won't make any difference :-)!

Perhaps you were thinking of trying to force DBI to quote the value (just
guessing)? But I used a placeholder (the ?) to get DBI to do this /without me
having to hold DBI's hand/ as to what needs quoting.

Long Live Placeholders!

--
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


.