Wouldn't just setting the value to DecimalFormat(Number) work? that instructs coldfusion to keep it as decimals - and when it updates your db - as long as that field is set to numbers and decimal it should all work. jay
Robert Orlini wrote: > I know this was answered nicely before and I tried the suggestion, but it did not >work. > > In Access I have quite a few number fields that I want to display figures with >decimals such as: 210.52. When I do a SQL update using CF it rounds off the decimal >place and I get 201 as data. > > I set the field for number and as Long Integer and General Number and Auto Decimal >in the field properties. The Default Value is 0. > > Any other way I can prevent Access from auto-rounding? > > Thanks. > > Robert O. > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
