[thelist] Effcient ASP Script?
jerryscannell at cox.net
jerryscannell at cox.net
Mon Nov 25 14:56:01 CST 2002
Adam,
Your loop will continue to run until EOF. What you need to do is stop the loop once you have updated the 2000th record. The way to do that is by adding an "else" to your loop. Like this:
Dim updCount
updCount = 0
do until rs.obj
if updCount < 2000 then
' Place your update code here
updCount = updCount + 1
else
exit do
end if
rs.moveNext
loop
Jerry
More information about the thelist
mailing list