Yeah, for some reason I am thinking Oracle will not let you but do not have access presently to test it. I think you have to make another column and move it over method.
On 8/28/07, Brian Kotek <[EMAIL PROTECTED]> wrote: > > 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. > > > > > > > > > > > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:287337 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
