[thelist] Effcient ASP Script?

[jerryscannell at cox.net]

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