You're right...the extra overhead on the database is not worth the saved 20 characters in typing and one conditional statement.
Thx -----Original Message----- From: Joe Eugene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:58 PM To: CF-Talk Subject: RE: ORDER BY and UPPER() By the time.. you implement low level access or use CAST/CONVERT/IsNumeric you would be faster(code) to just pass parameters (Upper(FieldName)) Or what not straght to the DB... If no more processing is needed.? -----Original Message----- From: Stacy Young [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:47 PM To: CF-Talk Subject: RE: ORDER BY and UPPER() I think so...but our place is locked down tighter than....well...it's tight. Being a financial institution I need to go thru a whole approval process to get read access on anything... -----Original Message----- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 6:44 PM To: CF-Talk Subject: RE: ORDER BY and UPPER() Isn't there a USER_TAB_COLUMNS view in Oracle? > -----Original Message----- > From: Stacy Young [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 17 July 2002 10:31 a.m. > To: CF-Talk > Subject: RE: ORDER BY and UPPER() > > > Can't have to do it at the DB level... > I'm trying to use DECODE right now...think it might work.... > > > -----Original Message----- > From: Todd [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 16, 2002 6:25 PM > To: CF-Talk > Subject: Re: ORDER BY and UPPER() > > Put a condition using isNumeric() ...? > > ~Todd > > At 06:20 PM 7/16/2002 -0400, you wrote: > >I've got a particular query in which I'd like to have the > ORDER BY clause > >dynamic so that I can pass it into my CFC as an argument. > Piece of cake > >except for a minor detail. If the order by column is a > string I need to use > >UPPER() in order for it to be ordered properly...and > contrary to that, if I > >use UPPER() and the column is numeric it gets casted to a > string !! Catch > >22. There may be a simple solution...anyone have a suggestion? > > > > > > > >Using Oracle. > > > > > > > >ThX! > > > > > > > >Stacy Young > >System Integration Specialist, Architecture > >Surefire Commerce > >http://www.sfcommerce.com <http://www.sfcommerce.com> > >(p) 514-380-2700 ext: 3234 > >(f) 514-380-2760 > > Dang Stace, you need a shorter disclaimer! > > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
