You could try defining the var as price as decimal(5, 2)
HTH On 01/09/05, Matthew Small <[EMAIL PROTECTED]> wrote: > 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] > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:217096 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
