Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordset Iterating

Status
Not open for further replies.

link9

Programmer
Nov 28, 2000
3,387
US
Here is a small control statement that is not wanting to execute. It's timing out, and I can't figure out why.
Code:
while not sessionRS.eof
     thisValue = sessionRS("Q1")
     if thisValue >= 1 and thisValue <= 10 then
	     top3Total = top3Total + 1
     end if
     if thisValue >= 8 and thisValue <= 10 then
	     top3Valid = top3Valid + 1
     end if
     sessionRS.movenext
wend
sessionRS is the recordset created from the database. It may be helpful to know that the recordset is created from several tables (2000Data, demographics, opcsales, and others). If I comment the entire block out, the script executes fine, but when I try to let the block execute, the script hangs up here and times out.

If anyone can see what's wrong, I would appreciate you pointing it out for me.

Thanks,
Paul Prewett
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top