sql rounding numbers

  • 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?

  • 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

  • I am using sql server express, so I don't have access to sql profiler.

  • Do you have the ColdFusion debugger?. If so you can track the variable in ColdFusion to see it the problem exists within ColdFusion.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • 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