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.
Popular posts from this blog
Post data by ajax using coldfusion component
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
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