[thelist] Other ways to check for null

Casey aspnet at thecrookstons.com
Mon Nov 14 11:29:22 CST 2005


Ah shoot - this is classic ASP.


> 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