Creating a Decimal data column types take two arguments: precision and scale. Check to make sure that you have declared your column properly...
More.. CREATE TABLE FOO( myDecimal DECIMAL(5,4); ) Would generate a column that stores data like so 1.2345 >From the SQL SERVER Books OnLine: p (precision) Specifies the maximum total number of decimal digits that can be stored, both to the left and to the right of the decimal point. The precision must be a value from 1 through the maximum precision. The maximum precision is 38. The default precision is 18. s (scale) Specifies the maximum number of decimal digits that can be stored to the right of the decimal point. Scale must be a value from 0 through p. Scale can be specified only if precision is specified. The default scale is 0; therefore, 0 <= s <= p. Maximum storage sizes vary, based on the precision. HTH, Jeff Garza ----- Original Message ----- From: "Les Mizzell" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 05, 2002 11:20 AM Subject: SQL Database "Decimal" problem Hi, 1. Field data type is defined as "Decimal" 2. Insert/Update from form "1.234" 3. Look in database - value written is "1". It's getting truncated Suggestions? Thanks... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
