Hi all,
I've recently encountered the following problem. When I try to DELETE from
the Informix database using PHP I receive the following error:
Execute immediate fails : DELETE FROM table01 WHERE id=5 (E [SQLSTATE=IX
000 SQLCODE=-668]
The same SQL statement used directly in dbaccess works fine/user used is
the same. Other queries (like SELECT,etc.) work fine. Any idea where the
problem can be? The PHP code follows:
<?php
$conn_id = ifx_connect("database", "user", "password");
$result = ifx_query("DELETE FROM users WHERE id=5",$conn_id) or die("Query
failed!");
echo "Done.<BR>\n";
ifx_close($conn_id);
?>
Thanks for your thoughts,
-Mtx7-
--
mail.pt - Um mail para todos - em http://mail.pt/
--
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]
