Re: SQL CASE STATEMENTS

2009-01-19 Thread Barney Boisvert 
CASE is part of core SQL, not an MS extension in T-SQL.  But not
supported by QofQ either way.  Write to your local Adobe rep today!!

cheers,
barneyb

On 1/19/09, Andy Matthews  wrote:
> I don't believe you can use T-SQL case statements in a QofQ.
>
> -Original Message-
> From: Torrent Girl [mailto:torrentg...@gmail.com]
> Sent: Monday, January 19, 2009 8:19 AM
> To: cf-talk
> Subject: SQL CASE STATEMENTS
>
> Can I use case statements within a QoQ?
>
>
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318170
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

RE: SQL CASE STATEMENTS

2009-01-19 Thread Andy Matthews 
I don't believe you can use T-SQL case statements in a QofQ. 

-Original Message-
From: Torrent Girl [mailto:torrentg...@gmail.com] 
Sent: Monday, January 19, 2009 8:19 AM
To: cf-talk
Subject: SQL CASE STATEMENTS

Can I use case statements within a QoQ? 



~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318167
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

Re: SQL CASE STATEMENTS

2009-01-19 Thread Brian Kotek 
If you mean SQL case statements, no.

On Mon, Jan 19, 2009 at 9:19 AM, Torrent Girl  wrote:

> Can I use case statements within a QoQ?
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318165
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Re: SQL CASE STATEMENTS

2009-01-19 Thread John M Bliss 
If you're referring to something like the following, then sure:


select stuff
from stuff
where


things = 2


things = 1




On Mon, Jan 19, 2009 at 8:19 AM, Torrent Girl  wrote:

> Can I use case statements within a QoQ?
>
> 

~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318164
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4