I changed the datatypes to MONEY in the table and my SP and it all works fine now. Although I still don't understand why DECIMAL is an issue. It's confusing as to why the default settings of the DECIMAL datatype has a scale of 0.
Thanks for your help. Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] -----Original Message----- From: Matthew Small [mailto:[EMAIL PROTECTED] Sent: Thursday, September 01, 2005 10:35 AM To: CF-Talk Subject: RE: Sql Server DECIMAL datatype OK, I did this and it still does not help. I don't understand why this is a problem. Could by chance is the decimal datatype in the SP be the problem? I'm going to check into that, but I don't quite know how to fix the problem if it is. It basically looks like: StoredProc TableId as int, Price as decimal, etc.... Is there a way to define the decimal datatype for Price so it has a scale of 2? Thank you, Matthew Small Web Developer American City Business Journals 704-973-1045 [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:217095 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
