EOF error trapping

[Tom Petersen]

I am trying figure this out, I am using the example from aspfaq dot com
<%
If not objRS.EOF then

DO WHILE NOT objRS.EOF
%>
<p align="left"><font face="Arial" size="1">Posted by <%=
objRS("name") %> on <%= objRS("date") %> at <%= objRS("time") %></font></td>

<%
objRS.MoveNext
Loop
else
response.write "No comments posted yet."
end if

%>

If my db doesn't have a record I still get this:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested
operation requires a current record.

If it does have a record it works as it should. Am I missing something
really obvious?

[Ray at]

Well, I don't see anything really obvious. Are you sure this is where the
error's occurring? Do you have any other code that tries to pull in values
from objRS outside of the If/Then block? What code comes just before this
snippet and just after it?

Ray at home

"Tom Petersen" <pe****@sdsd.sdbor.edu> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I am trying figure this out, I am using the example from aspfaq dot com
<%
If not objRS.EOF then

DO WHILE NOT objRS.EOF
%>
<p align="left"><font face="Arial" size="1">Posted by <%=
objRS("name") %> on <%= objRS("date") %> at <%= objRS("time") %></font></td>
<%
objRS.MoveNext
Loop
else
response.write "No comments posted yet."
end if

%>

If my db doesn't have a record I still get this:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

If it does have a record it works as it should. Am I missing something
really obvious?

[Tom Petersen]

Nice catch Ray!
I changed this:
<FORM name ="add" METHOD="POST" action="comrslt.asp?action=add&topic=<%
=objRS("topic") %>">
to this:
<FORM name ="add" METHOD="POST" action="comrslt.asp?action=add&topic=<%
=strID %>">
and that took care of the problem, it wasn't the error trapping code at all.
"Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
message news:uh**************@tk2msftngp13.phx.gbl...

Well, I don't see anything really obvious. Are you sure this is where the
error's occurring? Do you have any other code that tries to pull in values from objRS outside of the If/Then block? What code comes just before this
snippet and just after it?

Ray at home

"Tom Petersen" <pe****@sdsd.sdbor.edu> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

I am trying figure this out, I am using the example from aspfaq dot com
<%
If not objRS.EOF then

DO WHILE NOT objRS.EOF
%>
<p align="left"><font face="Arial" size="1">Posted by <%=
objRS("name") %> on <%= objRS("date") %> at <%= objRS("time")

%></font></td>

<%
objRS.MoveNext
Loop
else
response.write "No comments posted yet."
end if

%>

If my db doesn't have a record I still get this:
Error Type:
ADODB.Field (0x80020009)
Either BOF or EOF is True, or the current record has been deleted.

Requested

operation requires a current record.

If it does have a record it works as it should. Am I missing something
really obvious?