September 5, 2009 at 3:07 pm
I am sending decimal numbers to sql server 2008 express from Flex 3 using ColdFusion. If I set a default value of say 1.5 and send that to sql server it puts it into the table as 2.00. If I do an insertion directly in sql manager the number appears as it should 1.5. Why is it rounding up when I send from flex. This is happening no matter what data type I am using, decimal(4,2), money, float, numeric(6.2).
Can anyone shed some light on this problem?
September 6, 2009 at 5:15 am
One logical possibility is that the client or driver is converting the value to an integer type.
Try tracing the connection with SQL Profiler to see the text of the statement that is arriving at the SQL Server.
If the statement shows a '2', you know it isn't SQL Server doing the conversion.
As always, the more information you post, the better chance we have of helping effectively...
Paul
September 6, 2009 at 8:09 am
I am using sql server express, so I don't have access to sql profiler.
September 6, 2009 at 8:51 am
Do you have the ColdFusion debugger?. If so you can track the variable in ColdFusion to see it the problem exists within ColdFusion.
September 6, 2009 at 3:29 pm
MalindaB (9/6/2009)
I am using sql server express, so I don't have access to sql profiler.
There are at least three things you could do:
1) Download the evaluation edition of SQL Server, which does include Profiler.
2) Try the open-source and free Profiler for Express here[/url]
3) Invest a small sum of money in Developer Edition
Paul
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply