Was that datatype is set and the column is populated will it let you change the scale to a number lower than what it has?
On 8/28/07, Brian Kotek <[EMAIL PROTECTED]> wrote: > > 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. > > > > > > > > >> > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:287331 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
