Informix DELETE problem
| From: | Misterio X . - Anonymo | Date: | Tue, 08 May 2001 10:08:11 +0000 |
| Subject: | Informix DELETE problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-9165@lists.php.net to get a copy of this message | ||
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/