No typo. We're using an SQL Server 8. >>> [EMAIL PROTECTED] 4/10/2006 12:28 pm >>>
He wants it when the ucDescription contains that value and is not just equal to it or was that a typo in his CFIF? The case when then method may not work depending on what DB he is using and the version of it. On 10/3/06, Jim Wright <[EMAIL PROTECTED]> wrote: > > Adrian Wagner wrote: > > Use a CASE statement in your SQL... > <cfquery datasource="computedColumnTest" name="testquery"> > SELECT ucDescription, ucTitle, > CASE WHEN ucDescription = 'Graduate Certificate' THEN 1 ELSE 2 END AS seq > FROM testtable > ORDER BY seq > </cfquery> > -- Aaron Rouse http://www.happyhacker.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
