Query of query Max Case Error
I tried to execute a stored procedure then tried to perform MAX Case select of the cached query. CF return me "Query of query syntax error". Can someone pls
shed a light?
<cfstoredproc procedure="Testing" cachedwithin="#CreateTimeSpan(1,0,0,0)#"
USERNAME="#SP_U#" PASSWORD="#SP_P#" DATASOURCE="#SP_DSN#" DBTYPE="ODBC" RETURNCODE="yes">
<cfprocresult name="qResults">
</cfstoredproc>
<cfquery name="QoQ" dbtype="query">
Select Max( Case Choice When 'A' Then 1 Else 2 End) As C
</cfquery>
