Im using the below code to create a CSV file on the fly. It works
great.
The problem is if I am exporting a date, excel translates it into
numbers. I tried forcing a single quote in front of each value, but then
each value is displayed in its cell with preceding and ending double
quotes.
Help?
<cfheader name="content-disposition" value="inline;
filename=#arguments.filename#.csv">
<cfcontent
type="application/unknown"><cfoutput>#UCase(arguments.columnHeaders)#</cfoutput>
<cfoutput query="inputquery"><cfset lineoutput = ""><cfloop
list="#variables.control#" index="column"><cfset lineoutput =
listappend(lineoutput,'"#evaluate("inputquery.#column#")#"')></cfif></cfloop>#lineoutput#
</cfoutput>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
