ADODB.Field error '80020009'

[anon007]

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/notes/view.asp, line 0

I am getting this error and I don't know why because it had been working fine. I did miss with the digram feature of the SQL Server but it shouldn't have effected that I don't think. Below you will see the trap I use to catch this error but it don't work ether. Any Help ?

If Not rs.EOF=False Or ID="" Then
Response.Write("<tr bgcolor='" & strRowColor & "'>")
Response.Write("<td width='100%'><b>No Results Found!<br><hr noshade color=#000000 size=1></td>")
Response.Write("</tr>")
Else

 

[gmmastros]

Are you filling the recordset with the results of a stored procedure?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[anon007]

No.

 

[anon007]

Its funny because it had been working fine.

 

[anon007]

I found it I had <%=rs("Name")%> before it had a chance to use the catch code so it was finding no records. Thanks