I'm not seeing any unexpected truncation with SqlServer 2000 sp3 on Windows 2000sp4 using CF8.
Per: http://livedocs.adobe.com/coldfusion/8/Variables_06.html "A real number can have up to 12 significant digits." I see SqlServer FLOAT values rounded to 12 significant digits in CF8. Two records with the same value in both a FLOAT column and a REAL column look like this in ColdFusion 8 and in Microsoft Query Analyzer: CF8 FLOAT REAL 123.456789012 123.45679 987.654321099 987.6543 Query Analyzer FLOAT REAL 123.456789012345 123.45679 987.65432109876497 987.6543 -tom- John Mason wrote: > Just to pass this along to see if we're not the only ones seeing this issue. > > If someone can confirm this, I'll pass it on to Adobe. > > It appears that CF 8 is truncating floats from Sql Server 2000. > > Thanks, > John Mason > [EMAIL PROTECTED] > 770.337.8363 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285998 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
