ASP-DB does not correctly handle NULL values when using Oracle as the backend. I use the following code to display and filter records:

Set MyDb=Server.CreateObject("AspDB.View&#34
MyDb.dbDBType = "ORACLE"
'use a unique unit identifier
MyDb.dbUnit = 1015
'Set its std properties
MyDb.dbNameMap = Session("AliasInfo&#34
MyDb.dbDSN="Dsn=X;UID=SA;PWD=SECRET"
MyDb.dbSQL="ACCTS"

'Use EMPTY_TBL table for dropdown values; since it has no records in it
'only Null will show up in the dropdown
MyDB.dbFilterDropFlds="(;,/+SSN,,EMPTY_TBL,ANYFIELD,,AddNull;"

MyDb.ASPdbView

When the form in submitted with the aspDebug=2 argument appended, the Setfilterinsql dump variable is:

Setfilterinsql=SELECT * FROM ACCTS WHERE PCT_DEFERRAL = Null

This syntax is not correct; Oracle uses IS NULL and IS NOT NULL to filter on fields for NULL values. The Setfilterinsql dump variable should read:

Setfilterinsql=SELECT * FROM ACCTS WHERE PCT_DEFERRAL IS Null

There should also be some means to filter do this:

Setfilterinsql=SELECT * FROM ACCTS WHERE PCT_DEFERRAL IS NOT Null

Thanks!