Informix DELETE problem

From: 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/

« previous php.db (#9165) next »