--On 30. August 2007 09:08:07 +0200 Lukas Zapletal <[EMAIL PROTECTED]> wrote:
Hello, I have a problem with "total-*" variables when suming results from MySQL 5.x. It does not work with monetary (float) numbers - only with integers. When trying to sum floats it cointanins nulls. IMHO the reason is in a driver because it probably do not convert numbers in national currency format (some countries, e.g. mine, do not use dot as separator). The problem is that the driver is outdated and old. Is there a fixaround? How could I for example convert the numbers explicitely? Or how do I ovverride the behaviour of the code that is responsible for the sumarizing?
Not sure how your issue relates to Zope. Zope basically only generates the queries using ZSQL methods and returns the results back. Check if this error also happens when you connect directly to MySQL using the standard Pytrhon DB-API.
Andreas
pgpVO60WfXL7G.pgp
Description: PGP signature
_______________________________________________ Zope-DB mailing list [email protected] http://mail.zope.org/mailman/listinfo/zope-db
