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
Post a Comment