Hi,

I am coding a search engine and message board in .ASP. The problem is I get this error:

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

I have tracked it down to this:

<%
while not rs.eof

%> <tr><td><a href="<% =rs("location") %>"> <% =rs("iteam") %> </a></td>
<td bgcolor="beige"> <% =rs("text") %> </td></tr>
<% rs.movenext

wend %>

That code is ran "if not (rs.eof) then".

Here is my Set statement:

set conn = server.createobject("adodb.connection")
conn.open "dsn=search"

set rs = conn.execute(SQL_String)

I have used this code before. I don't know what is up. I am running it on an access2000 database on iis 5.0 in IE 5.0. I don't understand how to fix it. Obviously there has to be data in the record set or the code would not even run because of my If statement!!

If you can help I would appreciate it,
Brandon