December 11, 2007 3:24pm
In SQLite you can't retrieve a row by testing the equality of a column with NULL.
This doesn't do what you think.SELECT * from table WHERE column = NULL;
You need to use IS NULL.SELECT * from table WHERE column IS NULL;
Happy now.