CFMX 7.0.2: Named parameter support

Related Categories: ColdFusion

Named parameter support in cfprocparam will be provided in an upcoming hot fix technote for ColdFusion MX 7.0.2. This was a sorely lost feature in CF 5.0 caused by the migration from ODBC to JDBC. Named parameters allow you to call stored procedure variables in any order. When CFMX was written, the JDBC 2.2 spec did not allow for named parameters, therefore CFMX ignored the dbvarname attribute in cfprocparam. Previous CFMX versions only supported stored procedure access via positional parameters. CFMX 7.0.2 JDBC drivers are JDBC 3.0 compliant, and this hot fix will re-enable the dbvarname attribute providing named parameter support.

The technote id is 24c08da9. You should download the 3.5 DataDirect drivers as well, see: DataDirect drivers not in CFMX 7.0.2.

Update: Adobe removed this technote and the link to the hot fix today (03/29/07) due to several instability complaints. Adobe development has confirmed several reported issues with this dbvarname fix. Adobe has also removed the the jar (hf702-52712.jar) from the CFMX 7.0.2 Cumulative Hot Fix 2 (chf7020002.jar).

Any customers who apply 7.0.2 CHF2 will also need to reapply the dbvarname hot fix -- if it is stable in your environment. Otherwise, once you put on 7.0.2 CHF2 dbvarname will no longer work.

Comments (1) | Print | Send | del.icio.us | Digg It! | Linking Blogs

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

[Add Comment] [Subscribe to Comments]

Thank you, thank you, thank you! That has been driving us mad for ages, especially the SPs that have 20+ params. So pleased this will get fixed. We have avoided the 7.02 upgrade for now as I didn't like the idea of the new Flex features going onto our production servers as it's not something we need (or want). But looks like we have a good reason to upgrade now.

# Posted By Gary Fenton | 9/27/06 4:35 AM

[Add Comment]