Re: Case statement inside cached query

2012-11-08 Thread Russ Michaels
se. 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'

Re: Case statement inside cached query

2012-11-08 Thread Carl Von Stetten
e. 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

Re: Case statement inside cached query

2012-11-08 Thread Matt Quackenbush
t 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 w

RE: Case statement inside cached query

2012-11-08 Thread Nathan Chen
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, N

Re: Case statement inside cached query

2012-11-07 Thread Matt Quackenbush
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 wrote: > > All: > > Do cached queries allow SQL case statement at all or is there

Case statement inside cached query

2012-11-07 Thread Nathan Chen
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 ~