Simple Loop Problem

puafo

Hi everyone,

I am relativly new to asp and am having a problem with a loop.

This is my select statement:

Expand|Select|Wrap|Line Numbers

 strSql = "SELECT newsletters.*, homePage.*, pointsTable.*, pointsTable.for-pointsTable.against as gd FROM newsletters, homePage, pointsTable ORDER BY pointsTable.points DESC, pointsTable.for-pointsTable.against DESC;"
 

This works perfectly when the loop code is taken out, but when it is in it creates the following error:

Expand|Select|Wrap|Line Numbers

 ADODB.Field error '80020009' 
 
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. 
 
/index.asp, line 0

I understand that it is trying to tell me there is no records in that field, but what I can't ubderstand is that if the loop is not there it works and if it is there it doesen't, frustrating!

Below is the looping code:

Expand|Select|Wrap|Line Numbers

 <%if NOT rscuafc.eof then

  do until rscuafc.eof%>

                        <tr>

                          <td bgcolor="#E6E6FF"><img src="images/spacer.gif" width="1" height="2"></td>

.

.

.

.

<td bgcolor="#CCCCCC"><img src="images/spacer.gif" width="1" height="1"></td>

</tr>

<%rscuafc.MoveNext

Loop

Else

response.write "Sorry, there are no records."

End If%>

any help would be greatly appreciated!

Thanks in advance.

jhardman

Doesn't "do until" execute once after the condition is reached? That could cause the problem. Try "do while NOT rscuafc.eof" instead.

Let me know if this helps.

Jared

iam_clint

or while not, i don't like do's

while not rsname.eof

rsname.movenext
wend

jhardman

Quote:

Originally Posted by iam_clint

or while not, i don't like do's

while not rsname.eof

rsname.movenext
wend

Hey Clint, could you clarify something for me? I was under the mpression that do while ... loop was the same as while ... wend. Is there a technical difference, or is it just a matter of preference?

Jared

iam_clint

preference really there are some differences i can't think of off the top of my head.

Simple Loop Problem

re: Simple Loop Problem

re: Simple Loop Problem

re: Simple Loop Problem

re: Simple Loop Problem

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about