My stored proc:
create procedure dbo.usp_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
My code:
<cfstoredproc procedure="usp_TestProc" datasource="test">
<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="qryDump" />
</cfstoredproc>
<cfdump var="#qryDump#">
With the above code, I get the correct results. Perhaps it is your
procedure creation?
Teddy
On 12/8/06, Konopka, Dave <[EMAIL PROTECTED]> wrote:
>
> Nope, I get:
>
> query - Top 1 of 1 Rows
> PARAM1 PARAM2 PARAM3 PARAM4 PARAM5
> What2 What3 What4 What5 What1
>
>
> -----Original Message-----
> From: Teddy Payne [mailto:[EMAIL PROTECTED]
> Sent: Friday, December 08, 2006 1:05 PM
> To: CF-Talk
> Subject: Re: ColdFusion update - dbvarname
>
> 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:263325
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
