Checking whether a recordset has or hasn’

I've the following 'typical' connection, executing a stored procedure and putting it on a recordset

Set cn = Server.CreateObject("ADODB.Connection")
cn.open "Provider=SQLOLEDB; Data Source=localhost; Initial Catalog=Intranet;User Id=sa; Password=;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open StoredProcedureName,1

I want to execute a Stored procedure that bring me some rows...
and I want to check whether it bring me rows or not....

but... as i try to do a rs.Recordcount, it raises an error.

How can I do it?

thanks in advance!

ljamal wrote: Use rs.EOF as in if rs.EOF then If it's true and you have just opened the record set then there are no rows in the record set.

Ok! thanks.. but when i do it I get the following error:


Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'EOF'


Here's my code:



Set cn = Server.CreateObject("ADODB.Connection")
cn.open "Provider=SQLOLEDB; Data Source=pecora3; Initial Catalog=Intranet;User Id=sa; Password=;"
Set rs = Server.CreateObject("ADODB.Recordset")
txtSP = "GetRed '110.40.11.0'"
rs = cn.Execute(txtSP)
if rs.EOF then
     Response.Write "No regs"
else
     Response.Write "1+ regs"
end if


Thanks!

ljamal wrote: rs = cn.Execute(txtSP) should be Set rs = cn.Execute(txtSP)

Thanks!! that was my  mistake!!!.... you've discovered it!!...

Now it works fine!