[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:


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.
Phone: 706.210.0168 
Fax: 413.812.4864

Monitor bandwidth usage on IIS6 in real-time:

More information about the thelist mailing list