title: How to tell if a call to SQL Execute() using ADO fails in classic ASP
body: <p>I have the following shortened classic ASP code that makes a SQL insert call...</p>
  
  <pre><code>cmd.CommandText = "insert into MyTable values(blah, blah, blah)"   
  cmd.CommandType = adCmdText
  
  Set rs = cmd.Execute()
  </code></pre>
  
  <p>Using the recordset that Execute() returns how can I tell whether the insertion was successful or not?</p>