In that case... your solution seems ingenious! ;-)
> -----Original Message-----
> From: Stacy Young [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 17 July 2002 10:47 a.m.
> 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!
> >
> >
> >
> >
>
>
______________________________________________________________________
Get the mailserver that powers this list at http://www.coolfusion.com
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
