RecordSet Field Empty 1

[Mighty]

Guys,

I have created a recordset using a LEFT OUTER JOIN to join together three tables. I have four fields in the recordset. As a result of the outer join, it is possible for one of the fields to contain no data. What I need to know is how to check if the field does not exist for a particular record.

I have tried:

if rs.Fields("GTYCOM&quot = "" then....
else.....

But it always goes into the else clause even if the field is empty. Any ideas?? Mise Le Meas,

Mighty

 

[jkat]

try Response.Writing("[" & rs.Fields("GTYCOM&quot & "]&quot
and make sure that it is indeed empty.

-Jas

 

[link9]

You can also use the isNull(value) function --

returns a simple true or false

 

[bgreenhouse]

There's also

if IsEmpty(FieldName) then
or if IsNulll(FieldName) then

It will assume you mean "If IsEmpty(fieldName) = true then" unless you specify otherwise.

I usually put all three in, i.e:

If fieldName = "" or IsEmpty(FieldName) or IsNull(FieldName) then...

Ben