Re: Writing a CSV file

["tclaremont"]

Here is the way I do it...

 <cfquery name="GetAll" datasource="#DSN#">
 SELECT Field1, Field2, Field3, Field4
 FROM tblName
 </cfquery>


 <cfheader name="Content-Disposition" value="filename=ReportName.csv">
 <CFCONTENT  reset="yes" TYPE="application/msexcel">
 <CFOUTPUT QUERY="GetAll">
 "#GetAll.Field1#","#GetAll.Field2#","#GetAll.Field3#","#GetAll.Field4#"
 </cfoutput>