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. > > > > > > > > > > > >> > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287332 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
