I am quering the database in the following and getting the average of feedback received. I pass the memberID to the function which I have verified to exist and I get nothing back. If I run the same query in the query analyzer I get a result of 2. Can anyone see a problem?
<!---GET THE AVG OF RATINGS FOR USERS---> <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> Where I want to use it <img src="images/#ratingAverage#_star.gif" border="0" align="absmiddle" alt="#ratingAverage# Star Rating!!" /> Doug B. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:266492 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
