Re: CFQUERY - Aggregate Function

How about tek-tips.com? Can any recommend a free forum like houseoffusion for SQL coding issues. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers,

Re: CFQUERY - Aggregate Function

or http://www.sswug.org/ - Original Message - From: Kris Jones [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Thursday, November 02, 2006 6:27 AM Subject: Re: CFQUERY - Aggregate Function How about tek-tips.com? Can any recommend a free forum like houseoffusion

RE: CFQUERY - Aggregate Function

From the 2nd query, I'm trying to extract only records from 2nd query where the average of avg(ratingvalue) =4 and I'm not sure how do do this. HAVING AVG(ratingvalue) = 4 Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber

Re: CFQUERY - Aggregate Function

I'm not sure what SQL Platform you're using or what your schema exactly like... i can only infer based on your queries. If you're doing a Query of Query i don't think CF supports advanced functionality like HAVING... but in SQL it would be something like this: SELECT RecipeID,