[Zope-DB] total- variables does not work with MySQL 5.x

Andreas Jung lists at zopyx.com
Thu Aug 30 03:12:49 EDT 2007



--On 30. August 2007 09:08:07 +0200 Lukas Zapletal 
<lukas.zapletal at gmail.com> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope-db/attachments/20070830/5ae92df5/attachment.bin


More information about the Zope-DB mailing list