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'
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
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
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
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
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
~
6 matches
Mail list logo