ID: 35248
Updated by: [EMAIL PROTECTED]
Reported By: jwellis at carlalbert dot edu
-Status: Open
+Status: Verified
Bug Type: SQLite related
Operating System: *
PHP Version: 5.1.0RC5
Previous Comments:
------------------------------------------------------------------------
[2005-11-16 23:28:26] jwellis at carlalbert dot edu
Description:
------------
When setting the result of sqlite_query to a result set, if there is an
error, error_msg is not set. Example:
$result = $db->query("asdfesdfa", SQLITE_NUM, $db_error);
i would like to note, however, that if i dont set the results into a
result set, it works just fine. Example:
$db->query("asdfesdfa", SQLITE_NUM, $db_error);
Reproduce code:
---------------
$db = new SQLiteDatabase("sqlite_db1");
$result = $db->query("asdfesdfa", SQLITE_NUM, $db_error);
print">> $db_error<br>\n";
$db->query("asdfesdfa", SQLITE_NUM, $db_error);
print">> $db_error<br>\n";
Expected result:
----------------
>> near "asdfesdfa": syntax error
>> near "asdfesdfa": syntax error
Actual result:
--------------
>>
>> near "asdfesdfa": syntax error
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=35248&edit=1