Paul, now's a good time to start a "select *" rant.  :)

Glad it works for you Les.

~Brad


-------- Original Message --------
Subject: Re: Order By question
From: Les Mizzell <lesm...@bellsouth.net>
Date: Wed, June 30, 2010 4:18 pm
To: cf-talk <cf-talk@houseoffusion.com>


Works the charm:

SELECT * FROM judges
ORDER BY CASE WHEN judge_id IN (2589,7555) THEN 1 ELSE 0 END,
judge_lname


Thanks folks...




~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334999
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to