[thelist] SQL: checking for an empty date field
Tab Alleman
talleman at avweb.com
Thu, 6 Jan 2000 17:49:18 -0000
I am trying to execute the following SQL query:
SELECT * FROM Invoices WHERE Paid = Null AND SellerType = 1
"Paid" is a Date/Time field in an Access db. On Invoices that haven't been
paid, the field is blank (nothing has ever been entered into the field).
When I enter this statement directly into Access as a query, it works fine,
and returns exactly the records I want.
When I try to run it from an ASP page, I don't get errors, but it returns no
records, which is not correct.
How should I be doing this?