Thanks Andy. I do have those versions. But Python is 2.3.5 because I didnt want to move to 2.4.x as I think I read something in the README for Zope stating it was not tested for compatibility. (right?) I guess my thought is... Does 2.3.5 have the same issue as 2.4 regarding the decimals? For now, I am just going to setup 2.3.4 and run with it. I am assuming that you are the same adustman on the mysql-python project? Nice job on that, very cool stuff! On 5/12/05, Andy Dustman <farcepest@gmail.com> wrote:
On 5/12/05, Greg Fischer <retheoff@gmail.com> wrote:
I just moved my zope app from 2.7.3 to 2.7.6, plus the mysql db from 5.0.0 to 5.0.4. After moving everything, I noticed all of my decimal fields that will no longer display their values in DTML unless I remove the dollars-and-cents fmt option.
What version of MySQL-python and ZMySQLDA are you using? For MySQL-5.0, you definitely need MySQL-python-1.2.0 or newer and ZMySQLDA-2.0.9b3. You aren't using Python-2.4 by any chance, are you? 2.4 has a decimal type, which MySQL-python will make use of, if it's there, and the DECIMAL columns are returned using the Python decimal type. Previously they would have been returned as strings, and that might account for your breakage.
-- Computer interfaces should never be made of meat. http://www.terrybisson.com/meat.html _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
-- Greg Fischer 1st Byte Solutions http://www.1stbyte.com