If the scale is set to 4 in the database then four decimal places is the correct value. Either CF7 or the JDBC driver that CF7 uses must have been dropping the extra decimal places, but that was technically incorrect behavior. If you don't want four decimal places, you should change the column data type or round the value in the SQL.
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. > > > > > >> > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
