It occurred to me that I should first ask if this issue is causing any problems, or if it is only an unexpected way to format a number? For example 0.00 = 0E-8. They are both the same number regardless of how they are displayed.
For clarification, which number has the unexpected formatting, the value pulled directly out of a database table and placed in the cfquery record set, the variable that is being assigned the value, or both? -Mike Chabot On Wed, Feb 16, 2011 at 12:29 PM, James Skemp <jsk...@wisbar.org> wrote: > > Thanks for the clarification questions, Mike. > > >What is the data type of the field in SQL Server? > > numeric(10,2) > > > If you run the query in Management Studio, what do you see for that > value? > > 0.00 > > > How are you outputting the value in CF to see the 0E-8 number? > > In a tossed error it was displayed in the stack trace and a cfdump of the > returned information from the initial cfquery call against the sp showed it > there as well. When it works, it's stored to a variable before being passed > to SQL via another query. > > > What tag are you using to call the stored procedure in ColdFusion? > > cfquery > > > Which version of MS SQL Server are you using? > > 64 bit, 2005 Standard edition SP3 > > > ~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:342339 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm