isNULL

[vlitim]

I am using the below to check to see if a field in the database is empty, but it just defaults to the top response!

Response.Write(cat("description&quot)

if IsNULL(cat("description&quot) then
Response.Write("&quot
else
Response.Write(&quot;<br><br>&quot
end if

any help please!??!

 

[RobV]

What is the cat() collection? A recordset? Yours,

Rob.

 

[vlitim]

Rob,

yep its a recordset

 

[RobV]

Are you sure that the query is correct? Do you use option explicit to make sure that all variables are correct?

Try using on error goto 0 to trap any possible errors. VBScript has a small bug in it that takes the True part of an IF statement if that IF contained an error:

on error resume next

IF (1/0) > 0 THEN  'generate division by zero error
   response.Write "True part"
ELSE
   response.Write "Else part"
END IF

The code fragment above will always print 'True part'. Yours,

Rob.