In tables where I need arbitrary sorting ability, I've set up a numeric "sortby" field, wherein I order items manually (could get tedious if you have 100 rows in a table, but I never have that many in an arbitrarily-sorted table). I set the default value to, say, 100 or 1000, so that items are automatically low-sort priority by default. I value my first priority item 10, my second item 20, and so on. Then I ORDER BY that field in my SQL.
You could make a simple javascript/CF sorting app to take care of your sorting, if you grow tired of juggling numbers. If others have a better way, I'd like to know. Thanks, Jamie On Thu, 6 Dec 2001 09:32:40 -0800, in cf-talk you wrote: >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