I think he means the datatype of the column... You can get this from the database metadata. For example, with SQL Server you can use a variation of
SELECT INFORMATION_SCHEMA.COLUMNS.* FROM INFORMATION_SCHEMA.COLUMNS > -----Original Message----- > From: Todd [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 17 July 2002 10:25 a.m. > 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
