Create CSV file in Coldfusion Using CFFile

Create CSV file in Coldfusion Using CFFile

<cfquery name="GetUsers" datasource="TestDB">
    SELECT UserID, UserName, Password,Active,
    CASE Active
        WHEN 1 THEN 'Active'
        WHEN 0 THEN 'InActive'
        END AS Status
    FROM shema_users       
</cfquery>

<cfset HeaderColumn = "UserID,UserName,Password,Status">
<CFSET FileOutputPath = "C:\ColdFusion10\cfusion\wwwroot\Test\uploads">               
           
<CFFILE ACTION="Write" FILE="#FileOutputPath#\Users.csv" OUTPUT="#HeaderColumn#" nameconflict="overwrite" addnewline="yes">
                   
<cfloop query="GetUsers">  
    <cfset out_cols = "#UserID#,#UserName#,#Password#,#Status#">
                   
    <CFFILE ACTION="Append" FILE="#FileOutputPath#\Users.csv" OUTPUT="#out_cols#" addnewline="yes">
</cfloop>