Interesting issue... I am extracting a price from an XML feed for insertion into our local data. The price is returned as a simple float value which I can output to screen just fine. Unfortunately when I insert the info into the database it gets a little messed up.
Here are 5 inserted values from a small test run... 19.989999999999998 15.99 9.9900000000000002 14.99 39.990000000000002 As you can see, 2 of them inserted fine but 3 of them got inserted with a 0.000000000000002 margin of error. Does anyone know why this is happening? FYI: This is going into MSSQL but I get the same problems with MySQL so I don't think it is a DB issue. -- Jay -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.405 / Virus Database: 268.10.9/417 - Release Date: 11/08/2006 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:249705 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4