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 <[email protected]> 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
