Hey does anyone have a clear answer to this,
I can't include aggregate functions within a combined query, this is what I
am doing,
<cfif form.glimpseFormat eq "1">
<cfif form.criteria eq "1">
SELECT max(averFlow) as maxaverFlow,
(SELECT datePart(dd, dt)) AS day
FROM dbo.milford
WHERE datediff(day, dt, getdate()) = 0
<cfelseif .....
<cfelse>....
is it possible to combined aggregate functions?
this is my error
Column 'dbo.milford.dt' is invalid in the select list because it is not
contained in an aggregate function and there is no GROUP BY clause
Thanx in advance...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
