Hi everyone, can anyone tell me what is the meaning of this error:


ADODB.Field error '80020009'

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

Thank you..

I would have thought the error message was quite obvious but...

You have a recordset.

You have reached the start of the recordset or the end of the recordset and have tried to move past the last record (on one end of the other).

Alternatively the record you are referencing may have been deleted.

Just as a note BOF = Beginning of file, EOF = End of file.

When you try to get data from the record set, it is better to use

<%
If Not RS.BOF AND Not RS.EOF Then
/* get data from record set */
End If
%>

or you could even use

<%
do while not rs.eof
' Do stuff with data
loop
%>