I thought I should be more specific. The query I run pulls 19 records
IE: VIDEO CARD HDD RAM MODEM CPU SOUND CARD etc etc. I would like to order it like so.. CPU RAM HDD VIDEO CARD SOUND CARD This way the items are ordered to make sense for the dropdowns. ----- Original Message ----- From: "Douglas Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 06, 2001 9: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