add a new DB field with numbers to correspond to how you want to order so...
OrderField : Name ================= 1 : CPU 2 : RAM 3 : HDD 4 : VIDEO CARD 5 : SOUND CARD On Thu, 6 Dec 2001, Douglas Brown wrote: > 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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