I have a database with the following fields: 1) Status (it will hold values like "Open", "Closed", "Submitted"... etc...) 2) Closed (boolean field which contains 1 or 0)
If i enter a query like: Select * from Issues where Status != "Closed" i get all records (even the ones with Status=Closed). If i replace "Closed" by "Submitted" which is not also a field name the results are as expected. I think this is a bug. I use Apache. SQLITE Information from phpinfo(): SQLiteSQLite supportenabledPECL Module version2.0-dev $Id: sqlite.c,v 1.166.2.13.2.10 2007/12/31 07:20:11 sebastian Exp $SQLite Library2.8.17SQLite Encodingiso8859 _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
