I think that hotfix added support for named parameters in cfprocparam back in. Previously the dbvarname would be ignored. Make sure your parameter names are correct. (And, depending on your database settings, check the case as well.)
Cheers, Kris > Anybody getting errors with the hotfix? I've instaled in one of my > servers today and the website went down after a few hours of running. > The error is very wierd and does not says anything to me: > > Error Executing Database Query.[Macromedia][SQLServer JDBC > Driver][SQLServer]Line 1: Incorrect syntax near '='. The specific > sequence of files included or processed is: > C:\Inetpub\wwwroot\LocalUser\amazonia\index.cfm, line: 4 > > The stored proceedure wasn't change, nor the index.cfm file that calls > it. Sintax is > > 1 : <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" > DBVARNAME="IDidioma" VALUE="5"> > 2 : <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_INTEGER" > DBVARNAME="IDsite" VALUE="2"> > 3 : <CFPROCRESULT NAME="noticias_home" MAXROWS="5"> > 4 : </CFSTOREDPROC> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:262862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
