Nope that doesn't help either. I am pretty convinced the update has not really applied. The stored proc debugging output is showing the parameter dbVarName values as blank.
___________________________________ Dave Konopka Systems Programmer Wharton Computing and Information Technology E-mail: [EMAIL PROTECTED] Phone: (215) 898-2685 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 > > > > 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. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:263326 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
