Showing Column names in XSP

[Matthew Hailstone]

Title: Message

I'm trying to get the column names of a particular query, but with no luck so far. Here is a portion of my XSP source:

 

   <esql:connection>
     <esql:pool>wcart22</esql:pool>
     <esql:execute-query>
       <esql:query>select * from classes</esql:query>
      
       <esql:results>
         <xsp:logic>
           for(int i=0; i &lt; <esql:get-metadata/>.getColumnCount(); i++)
           {
             <field><xsp:expr><esql:get-metadata/>.getColumnName(i)</xsp:expr></field>
           }
         </xsp:logic>
         <esql:row-results>
           <para>
           <esql:get-columns/>
           </para>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

The above produces nothing.

The following source:

 

   <esql:connection>
     <esql:pool>wcart22</esql:pool>
     <esql:execute-query>
       <esql:query>select * from classes</esql:query>
       <esql:results>
         <esql:row-results>
           <para>
           <esql:get-columns/>
           </para>
         </esql:row-results>
       </esql:results>
     </esql:execute-query>
   </esql:connection>

produces the column name as an element and its respective value. (as expected)

 

Any help would be greatly appreciated. Thanks.

 

Matthew