Creating a csv file in ColdFusion

FileCSV.cfm

<cfset FilePath = "Path\To\The\File">
<cfset FileIs = "FileName.csv">
<cfset FileName = #FilePath#&#FileIs#>

<cffile action="write"
	file="#FileName#"
  output="Column1,Column2,Column3"
  addnewline="yes">
<cfoutput query="qMyQuery">
  <cffile action="append"
    file="#FileName#"
    output="#Col1_value#,#Col2_value#,#Col3_Value#"
    addnewline="yes">
</cfoutput>