Is the scale for the number column perhaps set to 4? I know in some prior version of CF we had some values from Oracle start showing up with one decimal place and it was due to a driver change in CF and how our columns were defined in the database. I thought though when that happened we had no precision/scale defined.
On 8/28/07, Asim Manzur <[EMAIL PROTECTED]> wrote: > > I have a same <cfquery> running in cf7 and cf8 > > CF7 dump shows it have int values like 1 and 2 and 3 etc. > > CF8 dump shows that the values being returned as 1.0000 and 2.0000 and > 3.0000 etc > > Can someone help please? > > Is there any settings that I need to change? > > Using Oracle Database. > > -- > ....................................... > Regards, > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

