Database-specific functions do not work in a Query of Queries.
On Thu, Nov 8, 2012 at 10:07 AM, Nathan Chen <nathan.c...@cu.edu> wrote: > > Matt, sorry I wasn't clear. I got a query of queries syntax error like > this: > Query Of Queries syntax error. > Encountered "sum ( case. Incorrect Select List, > > Nathan > > > > -----Original Message----- > From: Matt Quackenbush [mailto:quackfu...@gmail.com] > Sent: Wednesday, November 07, 2012 4:27 PM > To: cf-talk > Subject: Re: Case statement inside cached query > > > 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:353090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm