If you mean the difference in value: Enterprise manager is rounding the number off slightly, while CF displays the number with a larger number of significant digits. Computer floating point numbers almost always have some sort of 'inexactness', or rounding error, whatever you'd like to call it. This just has to do with the mathematics of storing floating point decimal numbers in a binary format.
If you mean the displayed format: (3.02...E-2 vs 0.32...), the first is scientific notation, while the second is the more commonly recognized represtentation. Scientific notation permits more signifigant digits to be displayed in a shorter form when dealing with very small or very large numbers. Use NumberFormat() to get CF to display the number in a more recognizable format. Jim ----- Original Message ----- From: "John McCosker" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 11, 2002 9:25 AM Subject: RE: sql data type wierdness > Sorry its a float length of 8 dataype, > > -----Original Message----- > From: John McCosker [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 11, 2002 4:22 PM > To: CF-Talk > Subject: sql data type wierdness > > > greetings, > > CF outputs this value from MS SQL SERVER 7.0 as > > " 3.0277780000000001E-2 ", > > in enterprise manager the value looks like this > > " 0.03027778 " > > any help would be appreciated, > > respectfully, > > J ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
