Export to excel, Column header display error in ColdFusion -


i trying account numbers query , displaying account numbers column header after exporting excel.

the following code working fine displaying wrongly:

<cfset variables.setheader = ""> <cfoutput query="myloop">      <cfset variables.setheader = variables.setheader & ", c_#myloop.acc#>  </cfoutput> 

the above code displaying column header (just 1 sample data showing here) showing 'c_000391'. wrong! display, 'c_' should not account number, account number should create column header alone. however, taking off 'c_' infront of #myloop.acc# giving following error:

the column name 000391 invalid.  

please let me know best solution(s) resolve toughest problem on earth :)

thanks

seems trying form comma separated list , try below , no looping required.

< cfset variables.setheader = valuelist(myloop.acc) >


Comments