your best bet is to do a union
ex:
SELECT
blahblah this is your USA query
FROM
cities
WHERE
country = USA
UNION
SELECT
blahblah your Non-us cities
FROM
cities
WHERE
country USA
try that.
a UNION "stacks" the queries on top of one another.
, 2000 1:33 PM
To: CF-Talk
Subject: RE: SQL Dropdown List
your best bet is to do a union
ex:
SELECT
blahblah this is your USA query
FROM
cities
WHERE
country = USA
UNION
SELECT
blahblah your Non-us cities
FROM
cities
WHERE
country USA
try
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
: http://www.fusioneers.com
ICQ: 346566
--
-Original Message-
From: Sean Daniels [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 11:34 AM
To: CF-Talk
Subject: RE: SQL Dropdown List
I usually add a "s
. This would be very easy to
maintain. H. 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
You'd have to test this and see if it's inefficient. I don't know how many
sites you have. But, how about two output loops:
CFQUERY - get all the countries, cities, etc and then
start your drop down box:
select
cfoutput
cfif myquery.country eq "USA"
OPTION
Remember, you don't HAVE to use the sortby for each row (you were already
onto that with your grouping idea. Just set the field default to like 99 and
then only specify a sortby value for rows you want at the top.
You can order by more than one column too, so order by "sortby" first, then
I see. That is a darned good idea. I will take it into consideration.
Thanks to everyone for helping on this!
Matthieu
-Original Message-
From: Sean Daniels [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 28, 2000 3:29 PM
To: CF-Talk
Subject: RE: SQL Dropdown List
fizer.com cc:
Subject: RE: SQL Dropdown List
9 matches
Mail list logo