Sean,
Thanks for the suggestion. Unfortunately, since I will be modifying this
list over time, it may start to become a headache to maintain. It is
already dreadfully long (not my choice), which means that determining and
entering the appropriate new sortby number (e.g., 3.5 or some other
'tween-the-integers option) might get worse than just leaving the
double-query method I am using now.
Your idea does, however, encourage me to consider adding an extra column for
sort groupings. If I give all the USA entries a 1, then the rest a 2, I can
use a two-column sort to get what I want. This would be very easy to
maintain. Hmmmm. I'm strongly considering it.
Thanks,
Matthieu
> -----Original Message-----
> From: Sean Daniels [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 28, 2000 2:34 PM
> To: CF-Talk
> Subject: RE: SQL Dropdown List
>
>
> I usually add a "sortby" field to all my lookup tables. Make
> it a smallint
> and then populate it with 1,2,3,4,5 depending on the way you want the
> Dropdown sorted. Then just do one query and order by
> "sortby". This gives
> youthe most flexibility. If you want Boston at the top for
> some reason, you
> can do that too.
>
> > USA (Albequerque) sortby=1
> > USA (Boston) sortby=2
> > USA (Chicago) sortby=3
> > Argentina (Buenos Aires) sortby=4
> > Bolivia (La Paz) sortby=5
> > Canada (Toronto) sortby=6
>
>
> - Sean
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists