title: ADO recordset EOF and BOF not as expected
body: <pre><code>arrBand = array("6M","10M","12M","15M","17M","20M","30M","40M","60M","80M","160M")
  </code></pre>
  
  <p>The stored proc is </p>
  
  <pre><code>SELECT * 
  FROM tableBand
  WHERE UCall=[In_Call] And ACID=[In_CID] and BAND=[In_Band];
  </code></pre>
  
  <p>The following code always executes the "not" condition. For a given CRS("CID") there are only 2 rows in the database that have one of the array values, i.e. 6M and 10M.</p>
  
  <pre><code>for i = 0 to UBound(arrBand)
    ConnTemp.GetMode SanCall, CRS("Cid"), arrBand(i), BandRS
    if not BandRS.EOF and not BandRS.BOF then
      tmp = tmp + "&lt;td style='width: 59px;'&gt;" + arrBand(i) + "&lt;input name='Ck'" +     arrBand(i) + "' type='checkbox' checked='checked'value='Y'/&gt;&lt;/td&gt;"
    else
     tmp = tmp + "&lt;td style='width: 59px;'&gt;" + arrBand(i) + "&lt;input name='Ck'" + arrBand(i) + "' type='checkbox'/&gt;&lt;/td&gt;"
  end if
  BandRS.close
  next
  </code></pre>