I also got it to work with SQL Server 2000 and 2005 Express using CF MX 7 Developer and Enterprise on windows XP on both systems.
The update was seamless. Teddy On 12/8/06, Steven Erat <[EMAIL PROTECTED]> wrote: > > 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:263371 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
