How can I over come this message with a resuts page. I have one site where and empty record will display the an empty results page and another site where the same situation returns this error:

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

I can't seem to find any difference in code. All I want is the results page to appear empty if there is no content in the DB.

Thanks

Stefan

Easy Enough.

Highlite the code on your page that DISPLAYS the recordset information (the recordset that may contain no data) And do a SERVER BEHAVIOR of "SHOW REGION > IF RECORDSET IS NOT EMPTY" and select the recordset.

Boom, you get no errors. An empty recordset does not cause the problem, however when you attempt to show the data in an empty recordset, you get that error.

Aegis Kleais
New Media Web Developer
(DWMX : IIS5.1 : SQL2K : WXP : ASP[VB/JS])