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! ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
