Do/Until loops?

[PogoWolf]

I have here a code snippet from my website..
I'm trying to build a drop down list from a database hit.

the issue is that this code sends the server into an never ending loop..

<% Do %>
<OPTION><%=RS.FIELDS(&quot;Handle&quot%></OPTION>
<% Loop Until RS.EOF = True %>

I know this type of a set up works in VB.. and thought
it would work in VBA.. I assume I'm messing something up in the loop clause.. but I can't see it..

Help? LOL =)
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[PogoWolf]

ok.. it MIGHT help if I put RS.MoveNext before the end of the loop... =)

I fixed it.. LOL
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com

 

[jonscott8]

<% Do %>
<OPTION><%=RS.FIELDS(&quot;Handle&quot%></OPTION>
<% RS.MoveNext
Loop Until RS.EOF = True %>

You simply forgot to move the record pointer.

Wouldnt the following be easier to read?

<% Do
Response.Write(&quot;<OPTION>&quot; & RS.FIELDS(&quot;Handle&quot&&quot;</OPTION>&quot
Loop Until RS.EOF = True %> Jon Hawkins

 

[PogoWolf]

Yes, that would be a little easier to read..I think I'll take you up on that suggestion. =)
---===///The PogoWolf\\\===---
Darkness..Bleakness..Plastic forks..?

http://www.pogowolf.com

http://www.xboxnewsnet.com