Hi All,

I just would like to ask, how do I handle null result set values queried from the database?

I tried using if-else statements to catch null values: if rs("column_name") is null then and if rs("column_name") = null then but to no avail. What is the proper way of handling null values from the database?

Using a Select query from the database, the result set using query analyzer looks like this:
Column1 Column2
0001 NULL
0002 NULL

Sorry to ask a very basic question. I'm new to ASP programming.

Thanks in advance!:)

isNull Function - Returns a Boolean value that indicates whether an expression contains no valid data ( Null).

IsNull(expression)

EG

if isNull(rs("column_name")) then
   'record has a null value
else
   'record is not null
end if

Wind is your friend
Matt
www.elitemarquees.com.au