Checking if the recordset is null?

[nitindel]

Hi All,

I am working on ASP VBScript...

How can i check the values of a recordset .i.e whether it contains values or not...??

Is NULL considered as a string....??

Actually i want to check on a precondion that if recodset is empty ...i want to take some action
if not empty then some other action..

please reply...

Code taht i have use is:-

SET objDBdbConnection = Server.CreateObject("ADODB.Connection")
objDBdbConnection.Open Session("ConnectionString")
SET rsNew =server.createobject("ADODB.Recordset")
StrSql = "Select IP from rate where docid=1"
rsNew.open StrSql, objDBdbConnection
 
if   rsNew.Fields("IP")="NULL" then
    Response.Write("Not Found")
else
    Response.Write("Found")
end if

Thanks :-)

[DrBunchman]

Hi Nitindel,

In order to check if a recordset has anything in it you can simply use the recordset.EOF property. This stands for End Of File and will be True if a recordset is empty. So, using your code:

 
if rsNew.EOF then
    Response.Write("Not Found")
else
    Response.Write("Found")
end if
 

And note that NULL is not considered as a string and is not the same as "".

I hope this help and let me know how you get on,

Dr B

[CroCrew]

Hello nitindel,

Checking if the recordset can be done in two ways:

Like DrBunchman said you can use (EOF):

If (rsNew.EOF) Then
    Response.Write("RecordSet in empty")
Else
    Response.Write("Record(s) are in the RecordSet")
End If
 

Or using the (RecordCount):

If (rsNew.RecordCount > 0) Then
    Response.Write("Record(s) are in the RecordSet")
Else
    Response.Write("RecordSet in empty")
End If
 

To check a field within the recordset is “NULL” then us the (IsNull):

If (IsNull(rsNew("IP"))) Then
    Response.Write("This Field is Null")
Else
    Response.Write("This Field is not Null")
End If
 

Keep in mind that “Null” and “” (blank value) are not one in the same.

Hope that explains it a bit more~

[markrawlingson]

if rsNew.Fields("IP")="NULL" then

-also note that "NULL" is not the same as NULL.

[ritman]

if rsNew.Fields("IP")=vbNULL then

[DagJ]

You can also use
If rsNew.State = 1 then 'if open then

Unfortunately none of the suggestions above will work if the recordset is NULL, i.e. Set rsNew = Nothing.