title: issue updating a table in a loop based on resultset from same table
body: <p>Consider the following (Semi-psuedocode):</p>
  
  <pre><code>CREATE TABLE foobar (
      id INT NOT NULL
      message VARCHAR(40) NOT NULL
  )
  
  INSERT INTO foobar (1, "hello");
  INSERT INTO foobar (2, "world");
  
  
  my $resultset = "SELECT * FROM foobar";
  while(!$resultset-&gt;EOF) {
      "UPDATE foobar SET message='blah' WHERE id = ".$resultset-&gt;id;
      $resultset-&gt;moveNext;
  }
  </code></pre>
  
  <p>In essence, I am trying to select all records from a table, and then loop over each one updating a few fields. However, when I do this, I get the following error:</p>
  
  <p>[Microsoft][SQL Server Native Client 10.0][SQL Server]A trigger returned a resultset and/or was running with SET NOCOUNT OFF while another outstanding result set was active. (SQL-42000) at continuous.pl line 493.</p>
  
  <p>The problem is that I am not running any triggers. I thought that maybe this was because I am trying to update an active result set, so I added the intermediary step of selecting all the data into a temp table, and then iterating over the temp table to update the original one, but I still get the same error.</p>
  
  <p>Any ideas what is going on?</p>