Jochem, good suggestion, then I can test for a numeric value. MS SQL Server does support this but then the application ends up being database specific and more cryptic to read. I could however live with that.
Maybe I'm making this a bigger deal than it is. Just seems there should be a more elegant expression for this written by the much smarter than me CF-developers here :) Jochem van Dieten wrote: > Check if your database support ordering by the ordinal number of the > column in the resultset, i.e. the following sorts by t.B: > SELECT > t.A > , t.B > , t.C > FROM > table t > ORDER BY > 2 > > Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4