RE: Rounding in Access
Change the number type to double. -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Friday, May 31, 2002 11:14 AM To: CF-Talk Subject: Rounding in Access 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. __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Rounding in Access
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. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rounding in Access
Set the type as a Single or Double. Long Integers hold only integer (i.e. no decimal) values. At 11:13 AM 5/31/2002 -0400, you 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. __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rounding in Access
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Rounding in Access
uh...sorry robert. marlon's right...that was a braindead reply on my part. setting the type to double should do it. ~ dina - Original Message - From: Marlon Moyer [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Friday, May 31, 2002 10:45 AM Subject: Re: Rounding in Access Set the type as a Single or Double. Long Integers hold only integer (i.e. no decimal) values. At 11:13 AM 5/31/2002 -0400, you 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. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists