I agree with you on this.
Greg Morphis wrote: > 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 >>> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4