title: how to loop through Query Columns in ColdFusion
body: <p>I have a query in a my CFC. The function contains a simple query as such.</p>
  
  <pre><code>&lt;cfquery name="qrySE" datasource=#mydatasource#&gt;
  SELECT
    NAMES,SALARY
  FROM tblTest
  &lt;/cfquery&gt;
  </code></pre>
  
  <p>I want to display my resultset as such (horizontally):</p>
  
  <pre>
  NAME1 NAME2 NAME3 NAME4
    10    20    45    62
  </pre>
  
  <p>Is there a way to loop through the columns of my query and create a virtual query for this purpose?</p>
  
  <p>If anyone has done this, please let me know.</p>