[thelist] Other ways to check for null
Casey
aspnet at thecrookstons.com
Mon Nov 14 11:28:57 CST 2005
Hmmm...
In the MS SQL database, the column "num_bedrooms" shows an empty cell when
queried for the record in question. It doesn't show <NULL> or any blank
spaces. Yet, it still executes the response.write. What ends up on the
screen is:
Bedrooms:
Is there some other way I should be checking for an empty value?
if not isnull(rs("num_bedrooms")) or trim(rs("num_bedrooms")) <> "" then
response.write("<b>Bedrooms:</b> " & rs("num_bedrooms") &
"<br><br>"
end if
Thanks,
Casey
More information about the thelist
mailing list