Problem having ADODB.Field error '800a0bcd'

When I execute my asp written page i encountered an error known as

<ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. >

But I've checked that my recordset did contain records and my session did not times out.

Can someone pls kindly point out to me what possibly cause this error? Ur help is very much appreciated. Thanks.

 

I would guess the problem is that your query returned 0 records and somewhere in your code you are trying to reference the recordset.

Without posting your code though it's tuff to tell...

Are you using a line similar to "if not rs.eof then" ?

 

When I get this error, its usually because my query returns no records and then I reference the recordset later.

Also check to make sure that you don't have 2 queries referencing the same recordset object, especially in a loop.

 

Ya, im using "if not rs.eof then"s looping condition. I solved the problem already, really thanks alot.