[thelist] Other ways to check for null
Joshua Olson
joshua at waetech.com
Mon Nov 14 11:42:14 CST 2005
> -----Original Message-----
> From: Casey
> Sent: Monday, November 14, 2005 12:29 PM
>
> 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:
Casey,
When you view the data via Enterprise Manager, is it displaying as NULL or
something else?
If EM is not showing that the value is null, you may loop through each of
the characters in ASP and output the ASCII value (using ASC()) value for
each character. That way you can see exactly what the string is.
<><><><><><><><><><>
Joshua L. Olson
WAE Tech Inc.
http://www.waetech.com/
Phone: 706.210.0168
Fax: 413.812.4864
Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/
More information about the thelist
mailing list