What is the data type of the field in SQL Server? If you run the query in Management Studio, what do you see for that value? How are you outputting the value in CF to see the 0E-8 number? What tag are you using to call the stored procedure in ColdFusion? Which version of MS SQL Server are you using?
-Mike Chabot On Wed, Feb 16, 2011 at 11:20 AM, James Skemp <jsk...@wisbar.org> wrote: > > Greetings. > > In one of our systems we're upgrading from ColdFusion 7 to CF 8. > > While testing a piece of functionality we were getting 0 returned as 0E-8 > for a query using a stored procedure. If the value is greater than 0, > there's no issue. > > Updating the procedure to cast the returned value as a numeric resolved the > issue, but since this functionality is working fine against CF 7 ... > > We're using MS SQL, and the data source settings in ColdFusion > Administrator are consistent between 7 and 8. > > Google and searching these forums isn't helping much, other than suggesting > it's coming out of MSSQL, but ... does anyone have any additional background > on why we're seeing this? Do we need to evaluate each of our > procedures/calls to verify that values are coming back correctly and cast if > not, or ...? > > Thanks! > > ~James > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342335 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm