that's very neat, chris! i didn't think one could use FIND_IN_SET in ORDER BY clause - live and learn!
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Chris Blackwell wrote: > You can do this in a very easy and elegant manner with MySQL. No need > for join or nasty case statements > SELECT * > FROM cities > WHERE state IN (<cfqueryparam value="#states#" list="yes">) > ORDER BY FIND_IN_SET(state, <cfqueryparam value="#states#">), city > > NB. the second cfqueryparam is not a list, its just a comma seperated string > like "NY,CA,FL" > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
