TechNote

ColdFusion MX 6.1: Hot fix for cfquery/cfqueryparam

Macromedia has created a hot fix to address the following issues with cfquery and cfqueryparam in Macromedia ColdFusion MX 6.1:

• 53852 - When a string expression is evaluated inside a cfquery tag, each single quote character is escaped to two single quotes. In certain cases, such as when complex CFML expressions are evaluated in a cfquery tag especially within a cfloop, the single quotes may be repeatedly escaped.
• 52305 - Function calls inside a cfqueryparam will result in all single quotes being doubled.

ColdFusion MX 6.1 - Server Configuration

Follow the instructions below to install the hot fix for ColdFusion MX 6.1 in the server configuration. For J2EE servers including JRun, use the instructions under the J2EE Configuration section.

Windows

1. Download the hot fix (22K).
2. Stop ColdFusion.
3. Create the directory cf_root\runtime\servers\lib if it does not exist.
4. Extract hf53852_61.jar from the downloaded ZIP file, into the following directory:
   cf_root\runtime\servers\lib\
5. Delete any existing class files from the cf_root\wwwroot\WEB-INF\cfclasses directory.
6. Restart ColdFusion.
7. Examine the ColdFusion MX Administrator System Information page and confirm that hot fix hf53852_61.jar shows in the Java Class Path list.

Unix

1. Download the hot fix (22K).
2. Stop ColdFusion.
3. Create the directory cf_root/runtime/servers/lib if it does not exist.
4. Extract hf53852_61.jar from the downloaded ZIP file, into the following directory :
   cf_root/runtime/servers/lib/
5. Edit the file cf_root/runtime/bin/jvm.config:
   1. Locate the JVM classpath section.
   2. Add {application.home}/runtime/servers/lib as the first entry in the java.class.path list.
      
      For example:
      # JVM classpath java.class.path={application.home}/runtime/servers/lib, {application.home}/runtime/../../src, {application.home}/lib/cfusion.jar, {application.home}/runtime/lib/webservices.jar
6. Delete any existing class files from the cf_root/wwwroot/WEB-INF/cfclasses directory.
7. Restart ColdFusion.
8. Examine the ColdFusion MX Administrator System Information page and confirm that hot fix hf53852_61.jar shows in the Java Class Path list.

ColdFusion MX 6.1 - J2EE Configuration
ColdFusion MX 6.1 - J2EE Configuration with JRun

Follow the instructions below to install the hot fix for ColdFusion MX 6.1 in the J2EE configuration with a J2EE server including JRun:

1. Download the hot fix (22K).
2. Extract hf53852_61.jar from the downloaded ZIP file, into the cf_root/WEB-INF/lib directory.
3. Change the Context Parameter cf.class.path
   in the Deployment Descriptor (cf_root/WEB-INF/web.xml)
   for the Web Application "Macromedia ColdFusion MX" (cfusion.war)
   
   from:
   ./WEB-INF/cfusion/lib/cfusion.jar
   
   to:
   ./WEB-INF/lib/hf53852_61.jar,./WEB-INF/cfusion/lib/cfusion.jar
   
   
   • Note that the two paths in cf.class.path each start with a period and are separated by a comma.
   • Do not confuse ./WEB-INF/lib (which contains the hot fix jar file) with ./WEB-INF/cfusion/lib (which contains cfusion.jar).
4. Delete any existing class files from the cf_root/WEB-INF/cfclasses directory.
5. Stop and restart the J2EE server for changes to take effect.
6. Examine the ColdFusion MX Administrator System Information page and confirm that hot fix hf53852_61.jar shows up in the Version section like 6,1,0 hf53852_61. Note: You will not see this jar in the Java Class Path because the hot fix jar is being loaded in the Coldfusion Class Path.
7. Repeat steps for each deployed instance of ColdFusion.

About changing the Deployment Descriptor

• Deployment Descriptor Context Parameters can be changed using the J2EE Administrator Control Panel (WebLogic and JRun) or by using the Application Assembly Tool (Websphere). If your J2EE server does not have such a tool, you must make sure that the Context Parameter change is made for all deployed instances of ColdFusion. It may be necessary to un-deploy CFMX, make the change, then re-deploy CFMX. See your J2EE documentation for other methods.
• Be sure to Persist (WebLogic) or Save (Websphere) your changes after you change the value for cf.class.path.
• You will usually need to stop and restart your J2EE server to make these changes effective.

Additional Information

---

• ColdFusion MX 6.1 confirmed issues (18795)
• ColdFusion hot fixes (all versions) (17883)

Search Support

---