I dont like using the order by 2 stuff simply because if the query has 42 columns, and it's 27 I'm looking for, it's a bitch to find.. it's easier to read "MONTHDATE" or whatever. Plus if the query changes, whoops.. gotta recount the items (unless its a small change of course)
On 9/17/07, Vince Collins <[EMAIL PROTECTED]> wrote: > 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 > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288624 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
