select * from tablename where field1 IS Null
> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Fabio Spadaro > Sent: Thursday, March 22, 2012 11:33 AM > To: General Discussion of SQLite Database > Subject: [sqlite] select null values in python > > Using sqlite3 python and I have a problem running a query. > My table has null values. Now if I do a 'select * from tablename' > returns to me as the result: > [(datetime.date (2012, 3, 22), buffer ptr <read-write > 0x0000000003774B90, > 0x0000000003774B58> at size 0, None, None, None, None, None, None)] > As you can see there are null values that in python are None type. > If I want to run a query like "select * from tablename where field1 = > Null" > returns no results and even if I run "select * from tablename where > field1 = None" None because there is not in Sqlite. You should use an > adapter or something? > > -- > Fabio Spadaro > > Try Sqlite Root a GUI Admin Tools for manage Sqlite Database: > www.sqliteroot.com > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
