Re: total- variables does not work with MySQL 5.x

--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

_______________________________________________
Zope-DB mailing list
[email protected]
http://mail.zope.org/mailman/listinfo/zope-db

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (Darwin)

iD8DBQFG1m30CJIWIbr9KYwRAs8MAKCjZZBnRKPuDYFezHY/WuvyuBJ6wQCfcO3i
ptcvsUc9x8D9rdjIDOEe6mw=
=hJ9j
-----END PGP SIGNATURE-----