Numbering with a do-loop within a while-wend 2

[Sonrie]

Hello,

I have made a table where I print out data from a database. I would like to number all of the rows using this code:

<%
Do While Not rs.EOF
i = 0
Response.Write(i)
i = i + 1
Loop
%>

This should appear within this code:

<% While ((Repeat1__numRows <> 0) AND (NOT rs.EOF)) %>

...

<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs.MoveNext()
Wend
%>

Can someone please help me out?

Sincerely,
Sonrie

 

[jackfl]

Don't you want your
i = 0
to be outside your
Do While Not rs.EOF
?

 

[BDC2]

You need to move you i = 0 outside the loop or it will reset every time

<%
i=0
While ((Repeat1__numRows <> 0) AND (NOT rs.EOF))
%>

...

<%
Repeat1__index=Repeat1__index+1
Repeat1__numRows=Repeat1__numRows-1
rs.MoveNext()
i=i+1
Wend
%>

BDC.

 

[BDC2]

...as jack says ;-)

BDC.

 

[Sonrie]

Hehe, yes, I do! ;O)

Thanks for the tip.

-Sonrie