Recordset Errors

nnrin · November 23rd, 2007, 11:20 AM

Can somebody help me with this error please

Code:

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

Thanks,

rstelma · November 26th, 2007, 02:37 PM

If you response.write your sql statement and run it against the database what kind of recordset do you get?

nnrin · December 7th, 2007, 11:53 AM

I figured it out.. Thanks so much Stelma for your response.

rstelma · December 10th, 2007, 03:16 PM

What did you do?

nnrin · December 11th, 2007, 12:29 PM

Oh there was no record in the database as I was trying to run the edit module... and I didn't do the RS.EOF...

rstelma · December 11th, 2007, 01:11 PM

OK. Thanks.