2. ASPRunnerPro General questions
  3. NULL in search
This topic is locked

NULL in search

 		8/10/2006 1:54:42 PM
ASPRunnerPro General questions
R
 Rhoffman author

Is it possible to have a "NOT Equal" search also include NULL values. I know using "Empty" finds NULLs, but a NOT = Ready only returns fields where data has been entered and is not equal to ready. Any field that is NULL is not returned.
J
 		Jane 8/11/2006

Hi,
you can do it editing generated ..._list.asp file.

Find following line:

if Request("not" & CStr(i))<>"" then sRet = " not (" & sRet & ") "



and replace it with this one:

if Request("not" & CStr(i))<>"" then sRet = "( not (" & sRet & ") " & " or " & AddWrappers(Request("FieldName")(i)) & " is null)"
R
 		Rhoffman author 8/11/2006

Works perfectly, Thanks Jane.