collumm names from DB to Excel

[fluiter]

I manage to download data fields from the Database in to an Excel file. Now i
would like to have the collomm names downloaded as well. Here is the code i'm
currently having. I <cfquery name='laden' datasource='issue'> SELECT * FROM
tbl_issue ORDER BY issue_number ASC </cfquery> <!--- set vars for special
chars ---> <cfset TabChar = Chr(9)> <cfset NewLine = Chr(13) &amp; Chr(10)>
<!--- set content type to invoke Excel ---> <cfcontent
type='application/msexcel'> <!--- suggest default name for XLS file ---> <!---
use 'Content-Disposition' in cfheader for Internet Explorer ---> <cfheader
name='Content-Disposition' value='filename=issue.xls'> <!--- output data using
cfloop &amp; cfoutput ---> <cfloop query='laden'>
<cfoutput>#laden.issue_number##TabChar##laden.inte rnal_nr##TabChar##laden.region
##TabChar##laden.channel##TabChar##laden.issue_typ e##TabChar##laden.vendor##TabC
har##laden.carrier##TabChar##laden.qrb_cat##TabCha r##laden.customer_impact##NewL
ine#</cfoutput> </cfloop>

[VillageX]

Since you have the field names in your code, the easiest thing you can do is to just type them in your code right above the start of your CFLOOP.

[philh]

If you narrow the columns in the SELECT statement to exactly what you need for
the output (instead of *), you can include this code before the CFLOOP:
<cfoutput> <cfloop index='thisfield' list='#laden.Columnlist#'>
#thisfield##TabChar# </cfloop> #NewLine# </cfoutput>