• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 453
  • Last Modified:

ASP Run Loop Twice

I want to run a loop twice. I know it would be more elegant to do all action in one loop but I'm struggling with the syntax and I need the same record set further down the code.  Is the first loop stopping the second?
While  (NOT rsAgents.EOF) 
'Do Action	
rsAgents.MoveNext()
Wend
 
While  (NOT rsAgents.EOF) 
'Do another Action	
rsAgents.MoveNext()
Wend

Open in new window

0
webdork
Asked:
webdork
  • 3
  • 2
1 Solution
 
Pearl_export_benCommented:
Hope This Helps :)

If you are struggling with code, feel free to open a question with more code and I'll happily debug and explain it to you in more detail
'Scenario 1:
While  (NOT rsAgents.EOF) 
'Do Action      
rsAgents.MoveNext()
Wend
 
'This will take you back up to the top line of your code
rsAgents.MoveFirst()
 
While  (NOT rsAgents.EOF) 
'Do another Action      
rsAgents.MoveNext()
Wend
 
 
'Scenario 2:
While NOT rsAgents.EOF
   Do Action 1
   Do Action 2
   rsAgents.MoveNext
Wend

Open in new window

0
 
Pearl_export_benCommented:
And just to add a little more - Yes the first loop was stopping the second.  The first loop would loop through all your results to EOF (End Of File or ResultSet) and then the second loop would pick up where the first left off - at the end of your data - and thus wouldn't be able to manipulate the already played with data.

Ben
0
 
Pearl_export_benCommented:
Triple post - I know its naughty - sorry :(

'This will take you back up to the top line of your code
SHOULD BE
'This will take you to the first result in your file/resultset - not the first line of your code.

Ben
0
 
webdorkAuthor Commented:
Too easy!
rsAgents.MoveFirst() did the trick.
Thanks.
0
 
webdorkAuthor Commented:
Oh Goody
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now