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=...