Re: CFQUERY - Aggregate Function

2006-11-02 Thread Kris Jones
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

2006-11-02 Thread Doug Brown
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

CFQUERY - Aggregate Function

2006-11-01 Thread coldfusion . developer
Can any recommend a free forum like houseoffusion for SQL coding issues. I've used sqlmag.com but they forums have little traffic. 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. 1st Query SELECT

RE: CFQUERY - Aggregate Function

2006-11-01 Thread Dave Watts
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

2006-11-01 Thread Ben Koshy
1:17 AM Subject: CFQUERY - Aggregate Function Can any recommend a free forum like houseoffusion for SQL coding issues. I've used sqlmag.com but they forums have little traffic. From the 2nd query, I'm trying to extract only records from 2nd query where the average of avg(ratingvalue) =4