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