I just tested this out and did a cfdump on the query output. The columns when dumped will be in alphabetical order as normal for cfdumps. Ohter than that, each parameter received the right value.
Teddy On 12/8/06, Teddy Payne <[EMAIL PROTECTED]> wrote: > > This is reporting out of order for you? > > Teddy > > > On 12/8/06, Konopka, Dave <[EMAIL PROTECTED]> wrote: > > > > Sure, here is an example of a proc > > > > CREATE PROCEDURE [dbo].[TestProc] > > @Param1 As varchar(60), > > @Param2 As varchar(60), > > @Param3 As varchar(60), > > @Param4 As varchar(60), > > @Param5 As varchar(60) > > AS > > BEGIN > > > > SELECT @Param1 as Param1, > > @Param2 as Param2, > > @Param3 as Param3, > > @Param4 as Param4, > > @Param5 as Param5 > > > > END > > > > And the cfstoredproc code: > > > > <cfstoredproc procedure="TestProc" datasource="xxxx" username="xxxx" > > password="xxxxx "> > > <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" > > dbVarName="@Param2" value="What2"> > > <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" > > dbVarName="@Param3" value="What3"> > > <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" > > dbVarName="@Param4" value="What4"> > > <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" > > dbVarName="@Param5" value="What5"> > > <cfprocparam type="IN" cfsqltype="CF_SQL_VARCHAR" > > dbVarName="@Param1" value="What1"> > > <cfprocresult name="dumperQuery" /> > > </cfstoredproc> > > > > Thanks for taking a look. > > > > -----Original Message----- > > From: Teddy Payne [mailto:[EMAIL PROTECTED] > > Sent: Friday, December 08, 2006 10:09 AM > > To: CF-Talk > > Subject: Re: ColdFusion update - dbvarname > > > > How are you naming the dbvarname? Can you offer a snippet of a strored > > proc > > call? > > > > I ran into this yesterday and ahd it resolved. > > > > Teddy > > > > > > On 12/8/06, Konopka, Dave <[EMAIL PROTECTED]> wrote: > > > > > > Has anyone else had any problems with the recent ColdFusion cumulative > > > update? I'm specifically looking for help with the dbvarname fix. > > > > > > > > > > > > We installed it on our 7.0.2 CF server, and expected problems from the > > > re-enabling of dbvarname. But even after verifying the install, and > > > restarting the machine, stored proc parameters are still being passed > > by > > > order only to the database. The dbvarname values seem to have no > > impact. > > > Am I missing something obvious? > > > > > > > > > > > > Our database is MS SQL Server 2000. > > > > > > ___________________________________ > > > Dave Konopka > > > Systems Programmer > > > Wharton Computing and Information Technology > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:263312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
