Did you: - Download the .zip file - Extract the .jar - Log into your admin tool - Click "System Information" - Click 'Browse" by "Update File" - Navigate to your .jar in teh directory applet - Click "Submit Changes"
? Teddy On 12/8/06, Konopka, Dave <[EMAIL PROTECTED]> wrote: > > 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:263328 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
