case statement in the ORDER BY should work. See http://www.devx.com/tips/Tip/17288
On Fri, May 14, 2010 at 9:24 AM, Les Mizzell <[email protected]> wrote: > > Is there a way to do an arbitrary sort order on a specific cell? > > For example, let's say I have a cell "colour". > Possible values: > 1. blue > 2. cyan > 3. green > 4. orange > 5. red > 6. silver > > I want to sort on this cell, BUT, I want the order to show all > > red first > blue second > green third > ... blah ... > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 5115 (20100514) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:333702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
