[PHP-DB] Interbase: how can I insert null values with placeholders?

[Kiss Marton]

Hi!

I like to insert null values with placeholders in ibase_query. But it
doesn't work.

$stmt = "insert into category_prop \n".
    "(id, category_id, category_prop_type_id, asinteger, asfloat,
ascurrency, asstring) \n".
    "values (gen_id(gen_category_prop_id,1),1097,109,?,?,?,?)";

$asinteger = null;
$asfloat = 2.5;
$ascurrency = 3;
$asstring = "apple";

$sth = ibase_query($dbh, $stmt,
    $asinteger,
    $asfloat,
    $ascurrency,
    $asstring);

This statement insert '0' instead null. Why?

Best Regards,
Kiss Marton
[EMAIL PROTECTED]




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]