It probably depends on the database. It might not let you, or it might let you with a warning that all the data will be truncated. If not, you might have to create a new column, copy the data with the appropriate rounding, then drop the old column and rename the new one to match the old one.
On 8/28/07, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > Erf, tried to correct it but hit send a little too quickly. Meant to type > "Once that" instead of "Was that" > > On 8/28/07, Aaron Rouse <[EMAIL PROTECTED]> wrote: > > > > 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. > > > > > > > > > > > > > > >> > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:287335 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
