>From what I recall, what I did when the similar issue happened to me is I just used the round function within Oracle and in my queries. Something like SELECT ROUND(ID) ID FROM MYTABLE I probably either did that or I made a view which did something similar. I do not recall any CF settings for it that can be done short of maybe trying different drivers for the connection to the database but that has caused adverse effects for me in the past when dealing with things like stored procedures.
On 8/28/07, Asim Manzur <[EMAIL PROTECTED]> wrote: > > 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:287318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
