18. I previously had the datatype as money, but am in the process of trying decimal right now. Scale 0. These are default entries.
Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 10:01 AM To: CF-Talk Subject: RE: Sql Server DECIMAL datatype Do you know what the precision is set to on the column? Dave -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 9:57 AM To: CF-Talk Subject: OT: Sql Server DECIMAL datatype Hi, I have a strange problem using the decimal datatype in MS SQL 2000. I have a "price" field in a table that is of the decimal datatype. I have a stored procedure that should store a decimal number into the table. However, when the number is stored, it is rounded as if it were an integer. I can't figure out what's going on with it. Does anybody have any pointers on how to use this datatype? BTW, I don't want to change this datatype to anything else just yet. Thank you, Matthew Small ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:217089 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
