Re: SQL CASE STATEMENTS

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

cfquery dbtype=query
select stuff
from stuff
where
cfswitch expression=#var#
cfcase value=7
things = 2
/cfcase
cfdefaultcase
things = 1
/cfdefaultcase
/cfswitch
/cfquery

On Mon, Jan 19, 2009 at 8:19 AM, Torrent Girl torrentg...@gmail.com 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

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 torrentg...@gmail.com 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 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 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 li...@commadelimited.com 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