In those situations, I usually have a "weight" column - these contain integers that allow you to order by:
tblRichPeople --------------- person weight ----------- ------- Bill Gates 1 Michael Jordan 3 Steve Jobs 2 Billy Cravens 4 select person from tblRichPeople order by weight ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 11:32 AM Subject: SQL? > I have a page where I am dynamically creating 20 dropdowns from a query, > and what I need to be able to do is order it exactly how I want. I > cannot use asc or desc. Is this possible in SQL? Maybe ordering it by > column names or something? > > > > DB > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists