Interbase: how can I insert null values with placeholders?
| From: | Kiss Marton | Date: | Fri, 06 Jul 2001 17:23:10 +0000 |
| Subject: | Interbase: how can I insert null values with placeholders? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10126@lists.php.net to get a copy of this message | ||
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
martin@eaglesoft.hu