GetDiscounts being rounded up
Hey Ray
As you can see from the attached screenshot, the actual discount (A) is being rounded up when passed to the database and displayed in the order details (B)
Cheers
Jamie
Hey Ray
As you can see from the attached screenshot, the actual discount (A) is being rounded up when passed to the database and displayed in the order details (B)
Cheers
Jamie
have managed to figure out why this was happening...was set as an INT in the database. changed it to VARCHAR and this sorted it out.
is VARCHAR the right one to use in this instance or should I choose something better?
Since it is a number you should probably have it as Double or Float.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.