[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