Hi there all. I'm new to the forum. I have a problem with chapter 15. To be precise, it occurs when I have coded as far as MenuForRegisteredUsers.asp and then choose type in details into register.asp and press submit. I get the following error:

Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/BegASP/AddUser.asp, line 20

I have checked for any spelling mistakes, any discrepencies with the code and also downloaded the source code and checked it against my own code, to no avail. Can anyone help?

Thanks, Greg

Hi there,

This error occurs when there is no record in the recordset you retrieved by executing a query (SQL statement) against the database.

Is the data supposed to be there? Does the table you query contain records at all?

It's always good practice to see if you have any results, before you use the recordset. This works like this:

' Create Recordset here
If Not myRecordset.EOF Then
  ' There *are* records
Else
  ' There are no records
End If

If this doesn't help, I suggest you post some code; I don't have the book, so I don't know what code you're referring to.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.