What does "wouldn't work" mean? Get results you didn't expect? If yes, what did you get and what did you expect? Get an exception? If yes, where's the stack trace?
On Wed, Nov 7, 2012 at 5:22 PM, Nathan Chen <nathan.c...@cu.edu> wrote: > > 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:353085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
