checking against a blank ado recordset

[gio2888]

I guess this questions good in between with vbscript/asp and sql coding. I am trying to check for blank or null on a recordset... the select statment returned blank when I ran it against sql analyzer. Yet when I check it in my asp code, I tried
check = isNULL(rs1("title&quot) //check return neither true or false

I tried if rs1("title&quot = "" //that did not work either

Please Help, thanks! (I will post this in sql forum as well)

 

[100dtl]

If Len(Trim(rs1("title&quot)) > 0 then ' theres something in?

else
its empty
end if

 

[onpnt]

retunred a null value or no records?

no records use EOF
If RS.EOF Then
do something
End If

empty column (record)
If IsNull(rs1("title&quot) Then
do something
End If

I know you tried the second but that leads me to believe your not getting records instead of empty ones.

_____________________________________________________________________
[sub]Where have all my friends gone to????[/sub]

http://www.onpntwebdesigns.com

 

[gio2888]

Yes, it is eof...thanks!