Whoa, that's a dandy little query! I see you've got "from table"... the cities are pulled from a properties table via "select distinct city from properties"
I guess I could use a QoQ in place of the table as the datasource. However, you mentioned that your query would "tack the prior cities onto the end" and I would prefer to keep the selected cities in the order they are naturally and reduce the chance of confusing the user. It may be that the only way I can do this without jQuery would be to run a query that returns the names of the cities selected and then place them on top. Then run another query to get all the cities in order. (Which seems to be what your single query does, too, Greg). Usually, I put the selected item in a single select on top and then list the rest, including the selected item again after that. Guess that would work ok. > -----Original Message----- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2008 3:35 PM > To: CF-Talk > Subject: Re: Is there a way to do this? > > You could do something like (not tested) > select distinct city, orderby from ( > select city, 2 as orderby > from table > where city < foo_city > union > select city, 1 as orderby > from table > where city >= foo_city > ) order by orderby, city > > that would tack the prior cities onto the end > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:308698 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
