Doug, Are you using InitAvgFeedback as a UDF or as part of a CFC? If it's used as a UDF, which looks like it based on what you've sent, all you need to do is use #InitAvgFeedback(memberID)#. No need for <cfinvoke>.
Hth, Michael > -----Original Message----- > From: Doug Brown [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 13, 2007 5:53 AM > To: CF-Talk > Subject: What am I missing? > > <CFFUNCTION name="InitAvgFeedback" access="public" output="false" > returntype="string" hint="Output the average rating for all feedback per > member"> > <CFARGUMENT name="memberID" required="yes" type="numeric"> > > <cfset var RatingAverage = ""> > > <CFQUERY datasource="#APPLICATION.DB#" username="#APPLICATION.UN#" > password="#APPLICATION.PW#"> > select avg(rating) AS ratings > from #APPLICATION.DBPRE#memberRatings > where TAuthorID = <CFQUERYPARAM cfsqltype="cf_sql_bigint" > value="#ARGUMENTS.MEMBERID#"> > </CFQUERY> > > <CFRETURN RatingAverage> > </CFFUNCTION> > > Then my invocation > > <CFINVOKE component="advertiser.components.commonQrys" > method = "returnAverage" > memberID = "#Val(attributes.memberID)#" > returnvariable = "RatingAverage"> > </CFINVOKE> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:266517 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
