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=...
In this example, we are using AJAX to handle the form submission with form validations, That's insert data into database table. Output : - On click Submit button: That form post the values on update.cfc file. On Successfully Submit data Screen : I hope this is useful for new coldfusion programmers. Thank You
Comments
Post a Comment