RE: Decimal to Decimal Error
It's your column spec. Decimal(3,1) means 3 digits are allowed, and 1 digit to the right of the decimal is allowed. You need to change it to Decimal(4,1) if you want those other values. Dave -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 10:24 AM To: CF-Talk Subject: Decimal to Decimal Error JRUN 4, Updater 5 CFMX 6.1 w/ updater SQL DB. Column is Decimal(3,1) I have a query in which I am trying to update a field of type Deciaml. cfqueryparam cfsqltype=CF_SQL_DECIMAL value=#attributes.contractDuration# scale=1 null=no / Values with 1 digit to the left of the decimal point work fine. Examples: 0.5 1.0 1.5 2.0 2.5 etc... However, values with 2 digits to the left of the decimal point throw an error. Examples: 10.0 10.5 11.0 11.5 12.0 etc The error is: [Macromedia][SQLServer JDBC Driver][SQLServer]Error converting data type decimal to decimal. Any ideas? Mike ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214784 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Decimal to Decimal Error
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] It's your column spec. Decimal(3,1) means 3 digits are allowed, and 1 digit to the right of the decimal is allowed. You need to change it to Decimal(4,1) if you want those other values. That is not correct. From BOL: 'p' Specifies the precision, or the number of digits the object can hold. 's' Specifies the scale, or the number of digits that can be placed to the right of the decimal point. p and s must observe the rule: 0 = s = p = 38. Decimal(3,1) is the correct spec. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214790 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
RE: Decimal to Decimal Error
My bad I thought the decimal (.) is included in the digits I must be thinking of a different database language. By the way, what is 'BOL' ? Dave -Original Message- From: Tangorre, Michael [mailto:[EMAIL PROTECTED] Sent: Friday, August 12, 2005 12:39 PM To: CF-Talk Subject: RE: Decimal to Decimal Error From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] It's your column spec. Decimal(3,1) means 3 digits are allowed, and 1 digit to the right of the decimal is allowed. You need to change it to Decimal(4,1) if you want those other values. That is not correct. From BOL: 'p' Specifies the precision, or the number of digits the object can hold. 's' Specifies the scale, or the number of digits that can be placed to the right of the decimal point. p and s must observe the rule: 0 = s = p = 38. Decimal(3,1) is the correct spec. ~| 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:214794 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
RE: Decimal to Decimal Error
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] By the way, what is 'BOL' ? Books On-Line from Microsoft. ~| 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:214796 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
RE: Decimal to Decimal Error
By the way, what is 'BOL' ? SQL Server Books Online. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:214840 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=89.70.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54