You got me pointed in a great new direction. I will figure out the details and if there is a better function then isNumeric for the data I am dealing with.
Thanks! -----Original Message----- From: Jim Wright [mailto:[EMAIL PROTECTED] Sent: Thursday, January 25, 2007 10:18 AM To: CF-Talk Subject: Re: SQL order by Jim Wright wrote: > I should point out one issue with the way I did it...the isnumeric > function is not perfect, and will resolve to true things that can't be > converted to INT...case in point... > > IsNumeric('1,0.') = 1 > CAST('1,0.' AS INT) throws an error > and further, you need to look at the numeric data you are converting...is it all ints...you may need to convert to something else...also, you can google on isreallynumeric and isreallyinteger...those are some custom functions I've used in the past. sorry about the multiple posts...headache...not thinking clearly. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267620 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
