sqlite3, qmarks, and NULL values
ldo at geek-central.gen.new_zealand
Fri May 22 04:43:10 EDT 2009
In message <mailman.424.1242778866.8015.python-list at python.org>, Mitchell L
> 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.
More information about the Python-list