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:267614
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
