If you applied it correctly, it will say soemthing like this under your System Information:
Update Level /C:/JRun4/servers/cfusion/cfusion-ear/cfusion-war/WEB-INF/cfusion/lib/updates/chf7020001.jar Teddy On 12/8/06, Teddy Payne <[EMAIL PROTECTED]> wrote: > > 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:263332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
