Rounding problem

If I add an item with the price 0.52 to the ecart, 0.52 is added
If I add an item with the price 5.17 to the ecart, 5.20 is added

How can I define the ecart so that 5.17 is added as 5.17?

In the Database the unitPrice is defined as float 10,2 the ItemPrice in the Ecart is defined as USD, Currency.

Thanks for any help

Does the price look correct on the page and in the database? It should allow you to add that amount, so something is causing it to not work correctly. If you give me FTP access and a url to reproduce I can try to help debugging it.

Thanks Ray

It looks correct in the datbase and on the detail page. Just inside the cart it's being rounded. FTP data added to pm

For some reason using a prepared statement in MySQLi was causing the value to be rounded. I can't figure out why. What I did to solve the problem is I added a property to the rsobj.js file that allows you to turn off prepared statements. That seems to have fixed it.

Thanks a lot Ray! But the updated file causes the following error on other pages (pm). I've renamed your new file for the detail page, so it runs now.

I made an update that should address this issue. If you still have problems please include a link to the page that has the problem so I can debug it.

Thanks a lot Ray. Seems to work fine now.