All: Do cached queries allow SQL case statement at all or is there a way to get around it? I am trying to put this inside a cached query such as : Sum( case when A = 'B' then C else 0 end) as D ( C is numeric field). It wouldn't work. I am on CF 8 and Oracle 11g.
Thanks. Nathan Chen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:353084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm