No record.

[discusmania]

Hello guys....
when there is no record of that criteria, my program will return this error. can someone tell me what to do?


ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted; the operation requested by the application requires a current record.

?



Thanks
new in web prog,

 

[Kirilla]

Hi.

I don't know your source, but try to insert this in source:

....
if(!your_recordset.EOF)
{
blabla .. your_recordset.MoveFirst();

}
....
After you open a recordset with a query and it is possible to return 0 record, you can't use any method of recordset. You have to examine you have at least 1 record.

regards, Kirilla

 

[hblackorby]

He's right, but try this syntax:

if not recordset.EOF then
'Do stuff here
end if

(his syntax was for ASP using JavaScript)

where recordset is the name of the recordset you created. You can't do
something = recordset("value&quot
if your SQL returned a blank recordset. You should always check for recordset.eof before attempting to do something with it.
Harold Blackorby
hblackorby@scoreinteractive.com
St. Louis, MO

 

[Kirilla]

Hi.

Harold has right, that is a JavaScript syntax, but I think it doesn't depend on you put in ASP, HTM, XSL or HTML.

regards, Kirilla