Slow query with cfqueryparam searching on indexed column containing hashes

Your issue may be related to VARCHAR vs NVARCHAR. These 2 links may help Querying MS SQL Server G/UUIDs from ColdFusion and nvarchar vs. varchar in SQL Server, BEWARE What might be happening is there is a setting in ColdFusion administrator if cfqueryparam sends varchars as unicode or not. If that setting does not match … Read more

Google Maps infoWindow only loading last record on markers

Add content as a property to marker object and use this.content in the event handler: var marker = new google.maps.Marker(options); marker.content=”<div>Content goes here….</div>”; var infoWindow = new google.maps.InfoWindow(); google.maps.event.addListener(marker, ‘click’, function () { infoWindow.setContent(this.content); infoWindow.open(this.getMap(), this); });

Compare password hashes between C# and ColdFusion (CFMX_COMPAT)

I looked through the Railo code as someone else here mentioned in comments. Following is CFMX_Compat ported to C# from the Railo Java source. See below for an example of usage. using System; using System.Collections.Generic; using System.Text; using System.Security.Cryptography; namespace RailoUtil { // SOURCE: Railo Source Code License LGPL v2 // http://wiki.getrailo.org/wiki/RailoLicense public class RailoCFMXCompat … Read more

ColdFusion not catching NoClassDefFoundError

Now that I have had more coffee, I do not think cfcatch is capable of catching a NoClassDefFoundError. According to the documentation, it only processes Exceptions: Exceptions are events that disrupt the normal flow of instructions in a ColdFusion page, such as failed database operations, missing include files, and developer-specified events. NoClassDefFoundError is an Error. … Read more

Invoke ColdFusion function using AJAX

If you have multiple functions in your cfm(even if you don’t), put them in a cfc. Then you can use the following url pattern to invoke a specific method. cfc named myEntityWS.cfc <cfcomponent> <cffunction name=”updateDescription” access=”remote” returntype=”string”> <cfargument name=”value” type=”string” required=”yes”> <cftry> your code here <cfcatch> <cfoutput> #cfcatch.Detail#<br /> #cfcatch.Message#<br /> #cfcatch.tagcontext[1].line#:#cfcatch.tagcontext[1].template# </cfoutput> </cfcatch> </cftry> … Read more

Coldfusion – variable field name when looping through database query results

Don’t use Evaluate() for things like that! It’s slow and should be avoided. <cfloop index=”i” from=”1″ to=”4″> <cfset foo = query[“foo” & i][query.CurrentRow]> </cfloop> Or, if you like: <cfloop index=”i” from=”1″ to=”4″> <cfset foo = query[“foo#i#”][query.CurrentRow]> </cfloop> Evaluate() is for evaluating bits of code. Don’t use it for things that can be solved more elegantly … Read more

ColdFusion https connection failure

If you are using cfhttp to connect via SSL (https) then the ColdFusion server definitely needs the certificate installed to successfully connect. Here is a previous answer that I gave on a similar issue: Here are the steps you need to perform in order to install the certificate to the Java keystore for ColdFusion. First, … Read more