Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Zope: DB
total- variables does not work with MySQL 5.x
 

Index | Next | Previous | View Flat


lukas.zapletal at gmail

Aug 30, 2007, 12:08 AM


Views: 1333
Permalink
total- variables does not work with MySQL 5.x

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?

Thanks

LZ

--
Lukas Zapletal
http://lukas.zapletalovi.com
_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Subject User Time
total- variables does not work with MySQL 5.x lukas.zapletal at gmail Aug 30, 2007, 12:08 AM
    Re: total- variables does not work with MySQL 5.x lists at zopyx Aug 30, 2007, 12:12 AM
    Re: total- variables does not work with MySQL 5.x charlie at egenix Aug 30, 2007, 1:49 AM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.