title: Detect if a names field exists in a record set
body: <p>Is it possible to check if a named field is within a record set?</p>
  
  <p>EG id, field1, field2, field3 have been selected.  Is it possible for VBScript to detect if field2 has been selected.  I am also hoping this is possible without looping</p>
  
  <p>Please assume I dont know, nor can see the actual SELECT.  I need to detect this after the query has been executed.</p>
  
  <p>This is how its done using a loop, I am also hoping this is possible without looping:</p>
  
  <pre><code>dim rs,field,foundField
  sql = "SELECT * from table;"
  set rs = conn.execute(sql)
  For Each field in rs.Fields
     if field.Name = "someFieldName" then 
        foundField = true 
    exit for
     else 
        foundField = false
     end if
  next
  </code></pre>
  
  <p>TYIA</p>