ADODB 0x80020009 error problem

[Halyn]

I am using MYSQL server have Select statement on one of the asp page. I am now getting the empty recordset error:

ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

I have double checked everything but nothing found. Can anyone help me why I'm getting 0x80020009 error message?

[absolute55]

The error message indicates your select query does not return any records. This indicate either your search criteria is inappropriate for the records or you have reached to the end of the file. If you want to avoid such kind of error messages then you can add a small statement in your code. It is as below:

IF not (RS.EOF and RS.BOF) then
'user specified action goes here
END IF

This means if you reach the end of file, you force the database not to display any error message but instead perform the action that I specified.

[MindSpace]

The above error occurs when accessing a recordset in an Active Server Pages (ASP) file that contains "Text" or "Blob" type data from a SQL table. When dealing with BLOB fields from SQL Server, you need to put them to the right of non-BLOB columns in the resultset. To be safe, you should also read the columns in left-to-right order, so if you have two BLOB columns as the last two columns in your resultset, read the first one and then the second.

[void]

This could be the problem with your SELECT statement. You might not have specified the correct entries because of which you are not getting any result. Also you have not coded for exceptional cases. It is always advised to have some code for exception handling. You can do so by adding statements something like below:

If not objRS1.EOF then 
Do Until objRS1.EOF 
..........
Loop
End If