Testing for 'NULLS' in recordsets

[JazzLeg]

Hi,

I need to be abvle to read a field from a recordset (from SQL 7) and if the field is null then I would like to take an action....

I've tried this:

if rs("field") is null then....

but this gives me an error "object required" even tho all my variables are declared.

thanks

 

[mit99mh]

if the default is null in the database the VarType of the returned data will indicate it is null

To test for this try

if( VarType ( objRS("someData&quot = 1 ) ) then
Response.write "Data is null"
else
Response.write "Data is not null"
end if


Hope this helps

 

[swampBoogie]

if isnull(rs("field&quot) then
...