Query Alteration with Coldfusion using Query of Queries (QoQ)
Using alteration in ColdFusion query we can be altered without effecting the identification of a cached query with QOQ.
Original Query Output.
After Alteration Query Output.
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=...
Comments
Post a Comment