Here is a small control statement that is not wanting to execute. It's timing out, and I can't figure out why.
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
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
If anyone can see what's wrong, I would appreciate you pointing it out for me.
Thanks,
Paul Prewett