Get database field names from table...

[bweno]

How do you get the database fieldnames from a table and display them using cfquery and cfoutput.

Thanks a million...

[JMGibson3]

Assuming you've run a query returning one row and want to display details
(alphabetically, see below). This example is for one record listing the fields
top to bottom, label/value. If you want to show a bunch of records all at
once with horizontal columns (a la Excel) <cfgrid> will do it for you
automatically. <cfset colList = yourQuery.ColumnList> <cfloop index='ColName'
list='#colList#'> <tr> <cfoutput> <td align=right><b>#colName#:</b></td>
<td>#Evaluate('yourQuery.' &amp; colName)#<br></td> </cfoutput> </tr> </cfloop>
You can also find/download a Custom tag to get them in physical DB sequence:
<CF_ColumnList Query='#yourQuery#' ColumnList='colList'>

[bweno]

That works great!!!! The cf_ tag is awesome... Is there anyway to set to a list
of the values of the fields. The cf_ tag use a loop statement and everytime I
try and set it to a list and then output it comes up just showing the last
field value... Thanks in advance for all your help! <cfloop list='#colList#'
index='col'> <cfoutput> <cfset thelist = ''> <cfset thelist =
listappend(thelist, '#col#')> </cfoutput> </cfloop> <cfoutput> #thelist#
</cfoutput>