"Tgone" <[EMAIL PROTECTED]> wrote: >Sybren Stuvel wrote: >> Tgone enlightened us with: >> > Sorry, when I print out the variable it displays as '15.0'. The >> > price is '15.00' in the database though. >> >> That's the same thing, isn't it? 15.0 == 15.000000000 > >Yes, they're both mathematically the same. I never said they weren't... > >> > Here's my code: >> > >> > product = Product.get(2) >> > print product.price # 15.0 >> >> Try string formatting: >> >> print '%.2f' % product.price > >That works. I expected Python to display the data exactly as it is in >the database, like most languages.
"Like most languages?" Name one. C and C++ certainly will not display this with two decimal places, unless you print it out with a %.2f format. DECIMAL is an SQL thing. Unless the language has a native decimal type, it cannot possibly know how to display it in the same format as your SQL. -- - Tim Roberts, [EMAIL PROTECTED] Providenza & Boekelheide, Inc. -- http://mail.python.org/mailman/listinfo/python-list