Get column names from sql query
844545Aug 18 2011 — edited Aug 19 2011Hello ...
I have a query and I need to get the names of its columns without having to hard code them.
example:
cursor blah is select A.emp, B.num, C.tel, B.jack from table1 A, table2 B, table3 C;
the way I have it now is like this (I am using a HTML table for an automailer)
<tr>
<td><b> emp </b></td>
<td><b> num </b></td>
<td><b> tel </b></td>
<td><b> jack</b></td>
</tr>
I want something to loop through and get me all the column names. So I dont have to mess with the HTML code when I add or remove columns from my query
Thanks