http://qs321.pair.com?node_id=97064

THuG has asked for the wisdom of the Perl Monks concerning the following question:

First off, I realize I am at a disadvantage. I'm using PerlScript to write ASPs that make SQL Queries to an Access DB. All I can say in my defense is I got sick of VBScript.

My current problem is with floating point numbers getting weird values when I pull them from the DB. For example, the ".98" in the DB field defined as a single becomes "0.980000019073486" when I pull it into a PerlScript scalar. I can redefine the DB field to be text and let the script do the conversion to float when I need it, but I'm hoping there is an answer that doesn't involve changing the DB.

Any ideas?

-Travis