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.


Comments

Post a Comment

Popular posts from this blog

Login with facebook using coldfusion

Image
Here is a example. How to make facebooklogin for a website using coldfusion?. Before start you make a account with facebook. Step 1 :  Create a app for your website using facebooklogin.here you can get app_key and secret_key. Step 2: Step 4:  You can see this screen :   Step 5:   After filling UserName and Password a screen show like this...    After click ok the redirect to logininformation:- Output in logininformation.cfm  I hope this is useful for you. if you are facing any problem write us in comment. we are happy to solve that problem.   For more details visit these links : -   http://developers.facebook.com/docs/facebook-login/   //Permissions   http://developers.facebook.com/docs/reference/login/   https://developers.facebook.com/docs/reference/api/user/
Read more

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

Get Previous One Day Data in Sql Server

Get Previous One Day Data in Sql Server using convert(), dateadd(), datediff() and getdate() sql functions and between operator. SELECT OrderID , CustomerID , OrderDateTime FROM [ DEMODB ] . [ dbo ] . [ Orders ] WHERE OrderDateTime   BETWEEN CONVERT ( VARCHAR ( 10 ) ,   DATEADD ( DAY , DATEDIFF ( DAY , 0 , GETDATE ( ) ) , - 1 ) , 101 ) + ' ' + '00:00:00' AND CONVERT ( VARCHAR ( 10 ) ,   DATEADD ( DAY , DATEDIFF ( DAY , 0 , GETDATE ( ) ) , - 1 ) , 101 ) + ' ' + '23:59:59'
Read more