I installed the CFMX 7.02 Cumulative Update 1, restarted CF, then ran
the test against SQL 2005. My test shows dbvarname worked and named
notation was used in the stored proc. Since the params were purposefully
put in the wrong order, the debug output of the SP call shows them as
TWO ONE, but the final result yields ONE TWO.
Here's the server info showing the updater jar:
Server Product ColdFusion MX
Version 7,0,2,142559
Edition Enterprise
Operating System Windows XP
OS Version 5.1
Update Level /C:/CFusionMX7/lib/updates/chf7020001.jar
And here's the result and parts of the debug output:
----------------------------------------
ONE, TWO
Debugging Information
ColdFusion Server Enterprise 7,0,2,142559
Template /dbvarname.cfm
Time Stamp 08-Dec-06 04:43 PM
---------
createProc (Datasource=sqlserver2005_merant, Time=0ms, Records=0) in
C:\docroot\dbvarname.cfm @ 16:43:42.042
create procedure sp_CFQADBVARTESTTABLE2
(
@p_VarName1 varchar(30),
@p_VarName2 varchar(30)
)
as
insert into CFQADBVARTESTTABLE2 (VarName1, VarName2) values
(@p_VarName1, @p_VarName2)
return 0
---------
sp_CFQADBVARTESTTABLE2 (Datasource=sqlserver2005_merant, Time=0ms) in
C:\docroot\dbvarname.cfm @ 16:43:42.042
parameters
type CFSQLType value variable dbVarName
IN CF_SQL_VARCHAR TWO
IN CF_SQL_VARCHAR ONE
----------------------------------------
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263365
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
