Posts

Showing posts with the label Struct

Load div content on scroll using coldfusion

Scroll.cfm <cfsetting showdebugoutput="no"> <style> .loading{         display: block;         margin: 0px auto;         text-align: center;     } </style> <script src="//ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <script> $(document).ready(function() {     var loading = false;     //initial track_load     var track_load = 1;     //a place for my crap     var loadContentDiv = $("#content");     //populate the initial content     loadContent(track_load);         $(window).scroll(function() { //detect page scroll                        if($(window).scrollTop() + $(window).height() == $(...

Query Alteration with Coldfusion using Query of Queries (QoQ)

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

array with struct in coldfusion

array with struct - Create Json using array with struct in coldfusion   <cfquery name="GetUsers" datasource="TestDB"> SELECT UserID, UserName,Active, CASE Active WHEN 1 THEN 'Active' WHEN 0 THEN 'InActive' END AS Status FROM shema_users </cfquery> <cfset resultStruct = Structnew() /> <cfset JsonArray = ArrayNew(1) /> <cfset Counter=1> <cfloop query="GetUsers"> <CFSET color = FormatBaseN(RandRange(0,255), 16)  & FormatBaseN(RandRange(0,255), 16)  & FormatBaseN(RandRange(0,255), 16)> <cfset JsonArray[Counter] = Structnew() /> <cfset JsonArray[Counter]["UserID"] = "#UserID#" /> <cfset JsonArray[Counter]["UserName"] = "#UserName#" /> <cfset JsonArray[Counter]["Active"] ...