Either BOF or EOF is True

[sladewilson]

I have created a simple price comparison web site. I have already specified which products will be included. Goto my homepage and then browse through the products. You will notice that becuase they do NOT have prices associated with the products I get 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.
------------------------------

What can I do in ASP to tell a visitor that there are no prices available to show for this particular item?

 

[sladewilson]

Opps... Website can be found at:

http://www.paintballratings.com

 

[mwolf00]

SET objRS = (execute your query here)

IF objRS.EOF then (recordset is empty - no data found) -- Just trying to help...
<--- This is a wolf? We need a new icon.......
mikewolf@tst-us.com