title: In VBS, return MySQL query results when using 'INSERT INTO'
body: <p>In VBS, taking the following example into consideration, what (if any) results are returned by the <code>Open()</code> method of the <code>ADODB.Recordset</code> object?</p>
  
  <pre><code>Dim CN : Set CN = CreateObject("ADODB.Connection")
  Dim RS : Set RS = CreateObject("ADODB.Recordset")
  
  CN.Open connectionString
  RS.Open ("INSERT INTO db.table (username, computer_name, count) VALUES ('Whoever', 'Whatever', '99');", CN, 3)
  </code></pre>
  
  <p>In this example, calling <code>RS.MoveFirst()</code> results in an error, suggesting that no records were actually returned by the call to <code>RS.Open()</code>, despite the query running successfully.  The error I receive is -</p>
  
  <blockquote>
    <p>Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.</p>
  </blockquote>
  
  <p>The reason I require this is because an ID is auto generated by the query, and I need that ID for my code.  I can of course run a <code>SELECT</code> query, but it seems odd that results wouldn't be returned.</p>