Try Price as decimal(9,2). Dave
-----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] ****************************************************************************************** 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:217097 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
