Query of Queries Case expression

[Zig Ziglar]

Eventhough I have searched this , I can't find an answer for this
Does queries of queries support the case function?

like this....
<cfquery name="gettotal" dbtype="query">
select SUM(case when getdeals.source = 1 then 1 else 0 end)
from getdeals
order by getdeals.source
</cfquery>

thanks!

[paross1]

To the best of my knowledge, Q-of-Q does not support CASE as one of its rather limited set of "internal" functions.

Phil

[Adam Cameron]

> To the best of my knowledge, Q-of-Q does not support CASE as one of its rather limited set of "internal" functions.

That's right.

Here's the long and the short of it (CFMX6.0, but hasn't changed, I think):

[url]http://livedocs.macromedia.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/using_recordsets4.htm[/url]

--
Adam

[MikerRoo]

You can often work around this with crafty use of WHERE clauses and UNION selects.