[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