Re: Are these valid SQL statement in a QonQ?

[C S]

>Max((DateDiff('d',queryname.columnname,now()))) AS Age
>
>Sum(IIf(DateDiff('d',queryname.columnname,now())<=90,1,0)) AS Response


I do not think so. AFAIK, QoQ only support basic aggregate functions like MAX 
and SUM, not DateDiff or IIF. 
http://livedocs.adobe.com/coldfusion/8/htmldocs/using_recordsets_8.html 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314635
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4