title: using "on error resume next" in classic ASP, and how to handle errors
body: <p>Good day all, I would like to ask a thing about <code>on error resume next</code></p>
  
  <p>let's assume we have a loop to navigate through a recordset like:</p>
  
  <pre><code>Do while not rs.EOF
  query = "UPDATE ...."    
  conn.execute(query)    
  rs.movenext
  loop
  </code></pre>
  
  <p>i would like to be sure the <code>UPDATE</code> is going good, and i would like to check if there is some problems, so I have put a debugging features in the code like:</p>
  
  <pre><code>Do while not rs.EOF
  query = "UPDATE ...."
  
  on error resume next
  
  conn.execute(query) 
  
  If Err.Number &lt;&gt; 0 Then
     Response.write(Err.Number)
     response.write("&lt;br&gt;")
     response.write(Err.description)
     response.write("&lt;br&gt;")
     response.write(query)
     response.write("&lt;br&gt;&lt;br&gt;")
  end if
  
  on error goto 0
  
  rs.movenext
  loop
  </code></pre>
  
  <p>the question is : during a loop, if it encounters an error, the next cycle will the error be there (and so triggers again the error block) ? or <code>on error goto 0</code> will clear the Err object?
  in other words, will it works as a error handling?</p>