sqlite3, qmarks, and NULL values

Fri May 22 04:43:10 EDT 2009

In message <mailman.424.1242778866.8015.python-list at python.org>, Mitchell L 
Model wrote:

> However, COL2 might be NULL. I can't figure out a value for y that would
> retrieve rows for which COL2 is NULL. It seems to me that I have to
> perform an awkward test to determine whether to execute a query with one
> question mark or two.

In SQL, NULL is supposed to be a special case, by design. Perhaps you 
shouldn't be using NULL in your data values here.