title: How to tell if a db update was successful?
body: <p>I'm trying to modify some legacy ASP classic code, and I don't know much about ASP.  How do I tell if a database Insert, Update, or Delete failed?  By 'failed', I mean it either threw an error or affected zero rows.</p>
  
  <p>Here's the code that was already in the ASP file that sets up the database connection:</p>
  
  <pre><code>On Error Resume Next
  Set objConn = Server.CreateObject("ADODB.Connection")
  objConn.Open "Provider=MSDAORA;Data Source=dbname;User Id=dbuser;Password=dbpw;"
  </code></pre>
  
  <p>There are a few Select statements that work like:</p>
  
  <pre><code>qry =  "select stuff here..."
  Set objRs = objConn.Execute(qry)
  </code></pre>
  
  <p>I understand how to get the results from the Select statements, but how do I get the results of a non-Select statement?  Using a result set doesn't seem like it'd be the right way to do it.  Or is it?</p>