[thelist] Other ways to check for null

Casey aspnet at thecrookstons.com
Mon Nov 14 11:28:57 CST 2005


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:


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") & 
end if



More information about the thelist mailing list