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:263308 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
