Thanks Aaron, Yes the scale and precision has been set in the oracle database.
Now the question is I don't want to change the DB structure, is there anyway to tell coldfusion to ignore the precision and scale? Will appriciate your responses. thanks, >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. > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
