Here are the steps you need to perform in order to install the certificate to the Java keystore for ColdFusion. First, be sure you are updating the correct cacerts file that ColdFusion is using. In case you have more than one JRE installed on that server. You can verify the JRE ColdFusion is using from … Read more
One Option: Setting a dynamic variable name: <cfset variables[“GC” & AID] = “Testing” /> Output the value of the dynamic variable name: <cfoutput>#variables[“GC” & AID]#</cfoutput> Another Option: Setting a dynamic variable name: <cfset variables[“GC#AID#”] = “Testing” /> Output the value of the dynamic variable name: <cfoutput>#variables[“GC#AID#”]#</cfoutput>
This is a reprint of a blog post I did back on June 13, 2007. I’ve been using this method for quite sometime and it works great! YMMV. Who doesn’t like user-defined functions (UDFs)? If you have done any programming, chances are that you have used them extensively. The biggest problem that people have with … Read more
Seeing you are NEW to ColdFusion what I would do is pick ONE FRAMEWORK and stick to it. At first it will be hard you will have problems and you will be tempted to drop the Framework you have chosen but don’t do it. After you have mastered one framework then you can learn the … Read more
I don’t get any CFErrors on the screen but my CFChart is blank. Ignoring the correct approach for a moment, the reason that happens is that you are using the incorrect cfsqltype for the parameters. So you are actually sending different values to the database (and consequently performing a different comparison) than you are thinking. … Read more
That is a server side setting in the ColdFusion admin, under settings. Prefix serialized JSON with. It is enabled by default for security. Protects web services, which return JSON data from cross-site scripting attacks by prefixing serialized JSON strings with a custom prefix.. Perhaps you had turned this off on your ColdFusion 8 server. I … Read more
While you are waiting for something more official, I will throw in my $0.02 … I did some digging and based on my observations (with an MS SQL datasource) I believe that: CF_SQL_NVARCHAR is not just an alias for CF_SQL_VARCHAR. It maps to the newer NVARCHAR jdbc type, which lets you to handle unicode values … Read more
ColdFusion, by design, escapes single quotes when interpolating variables within <cfquery> tags. To do what you want, you need to use the PreserveSingleQuotes() function. <cfquery …>#PreserveSingleQuotes(query)#</cfquery> This doesn’t address, however, the danger of SQL injection to which you are exposing yourself. Using <cfqueryparam> also allows your database to cache the query, which in most cases … Read more
If you don’t want to look for a solution, but just want to solve the problem, insert this key in your registry to suppress the notification: [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security] “ExtensionHardening”=dword:00000000 You can accomplish the above by doing the following: Open your Registry (Start -> Run -> regedit.exe) Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\12.0\EXCEL\SECURITY Right click in the right window and … Read more
This is because decimal numbers that “look” round in base 10, are not exactly representable in base 2 (which is what computers use to represent floating point numbers). Please see the article What Every Computer Scientist Should Know About Floating-Point Arithmetic for a detailed explanation of this problem and workarounds.