OK... good to know -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 3:04 PM To: CF-Talk Subject: RE: numbers with decimal places to the right
If you wanted a true decimal field (not money) then you would specify column type like this: DECIMAL(5,3) Where 5 is how many total digits you want (excluding the decimal) and 3 is how many digits you want to the RIGHT of the decimal. Dave -----Original Message----- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Friday, September 02, 2005 2:23 PM To: CF-Talk Subject: Re: numbers with decimal places to the right INT says you want integers: whole numbers without decimal parts. You should change the column to be MONEY, which will allow for fractional amounts (cents). cheers, barneyb ************************************************************************ ****************** The information contained in this message, including attachments, may contain privileged or confidential information that is intended to be delivered only to the person identified above. If you are not the intended recipient, or the person responsible for delivering this message to the intended recipient, ALLTEL requests that you immediately notify the sender and asks that you do not read the message or its attachments, and that you delete them without copying or sending them to anyone else. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217255 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
