also, shouldn't those 2 tables be joined together some how?

On Wed, Mar 9, 2011 at 8:00 PM, Torrent Girl <moniqueb...@gmail.com> wrote:

>
> Hi All
>
> I have the following function that I am TRYING to get the average of a sum
> of 2 added values.
>
>  <cffunction name="getAverageTotalCalls" access="public">
>   <cfargument name="employeeID"        type="numeric"  required="yes">
>   <cfargument name="dateWorked"        type="string"   required="yes">
>
>   <cfquery name="getAverageTotalCalls" datasource="XXXX">
>    SELECT avg(da.connects)+avg(sum(ad.acd)) as averageTotalCalls
>    FROM dialeragent da, agentDaily ad
>    WHERE da.employeeID = <cfqueryparam value="#arguments.employeeID#"
> cfsqltype="CF_SQL_NUMERIC" />
>
>        </cfquery>
>  <cfreturn getAverageTotalCalls>
> </cffunction>
>
> So basically, I need to get the average of "connects" (only one record),
> get the average of "acd" (can be multiple records so this needs to be summed
> first, then averaged) THEN I need to add these two values.
>
> Here is the error I am getting:
>
> Error Executing Database Query.
> Invalid use of group function
>
>
> Any suggestions?
>
> TIA
>
>
>
> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342879
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to