The situation is as follows: there's a website that connects sellers and buyers, like Ebay. Among other things the owner of the website needs to know the details of each transaction initialized from there. Essentially I am looking for a payment method that returns a digital receipt. Is it possible to do something like that with PayPal?...
I have a new app (Rails 2.3.8) that uses lots of money fields. I'm using the money gem (3.0.5) and the acts_as_money plugin. I've written a number of rspec model examples and everything seems to be working fine there. My problem is in defining forms for new & edit. As I've done in past projects for complex layouts, I extracted the basic...
I have an items table in my MySQL database with a DECIMAL(10,2) field called price. When fetching these values, is it safe to do calculations and such with these numbers in PHP? Or will I end up with potential rounding errors and things like that which are common when working with floating point data types? How does PHP handle these th...
Is there an arbitrary-precision alternative to money_format available that could take a string instead of a float as a parameter? It's not that I plan on doing calculations on trillions of monetary units, but after going through the trouble to properly handle monetary arithmetic without abusing floats, it'd be nice to have a function t...
I found this add-on for the Money gem which updates from the ECB European Central Bank (updates its rates every 24 hours) but I'm unsure how I should go about caching in my rails app which uses multiple currencies. http://github.com/RubyMoney/eu_central_bank eu_bank ||= EuCentralBank.new eu_bank.update_rates #Rails.cache.fetch('rates',...
Take the following example: >>> from decimal import Decimal >>> nrml_price = Decimal('0.59') >>> discounted = nrml_price / 3 # Taking 2/3 off the price with a coupon Decimal('0.1966666666666666666666666667') # Customers don't have fractions of a penny >>> (nrml_price / 3).quantize(D('0.00')) # So I quantize to get 2 decimal places De...
I've inherited a project in which monetary amounts use the double type. Worse, the framework it uses, and the framework's own classes, use double for money. The framework ORM also handles retrieval of values from (and storage to) the database. In the database money values are type number(19, 7), but the framework ORM maps them to dou...
Hi all, I have an idea of new software product but have no time to develop it myself. I have a bad experience in partnership with other person 50/50 (he fooled me in a while and stole my idea with source code) so I think about outsourcing the project. I have a fear that outsource product will be not as good as I expect and price will no...
In sql server management studio, data type- money, when I enter an amount with a decimal it automatically adds on zeros to fill up to the hundredths. How can I determine the amount of spaces after the decimal? ...
The Imaginary Scenario: The Affiliates earn money on my website by selling items/services/widgets to their clients. You can think of it as a simple affiliate program. This money is stored in a single account until the Affiliate requests their money. The Affiliates don't want to wait for a check to come in the mail; they want to log-on ...
What is the best way to store monetary values in MySql. I've seen this: decimal(5,2) but then you can't enter in more than $999.99 for the amount. I mean I know you can change the 5 to something else but this doesn't seem like the most appropriate way to do this.. then again I'm not sure that's why I'm posting. I've also seen storing ...
I need to load a Money value in a variable in SSIS using a "Execute SQL Task" component. I map the return column of a SELECT to a variable. I've declared the variable "UnknownMoney" as a Double or a Single, but i always receive the error: Error: 0xC002F309 at Load Dummy vars, Execute SQL Task: An error occurred while assigning a value t...
beloved s.o. (lowercase intended; indented, and, subsequently dedented), I have a long-term project in mind, and when it's done I will definitely show it to you. In the mean-time, as the title suggests, I will be attempting (nay, succeeding! think positively, right?!) at creating an internet-based company. Essentially, I hope to utili...
hi guys, i have some price values to display in my page. i am writing a function which takes the float price and returns the formatted currency val with currency code too.. like fnPrice(1001.01) should print $ 1,000.01 ...
Hi, are there any good solution for microtransactions/payments available to C++? Either a library or an JSON/HTTP api. I want to be able to allow payments with credit card, paypal and if possible, SMS and phone calls. Do you know of anything that fit's my needs? ...