title: Loop through column names and put them into variables. ASP
body: <p>I need to be able to loop through column names and put the coloumn name and it's value into a variable. My code looks like this. </p>
  
  <pre><code>SQL = "select column1, column2 from table1"
  set rs = conn.execute(SQL)
  
  For each fld in rs.fields
      fld.name = rs(fld.name)
  Next
  
  rs.close
  </code></pre>
  
  <p>But this is not working. How can I loop through the column names and set them as variables without having to specify each column name?</p>
  
  <p>Thanks</p>