http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
That's it right there! Before 5.0.3, they were unpacked, meaning
saved like a char. Now they are packed, fixed point numbers. This is
screwing up the python functions for fmt.
Well, I was trying to NOT redo all that code, but looks
OK well, I fixed it. At least on My zope server.
The function for dollars-and-cents in DT_Var.py was like this:
def dollars_and_cents(v, name='(Unknown name)', md={}):
try: return $%.2f % v
except: return ''
I changed it to this:
def dollars_and_cents(v, name='(Unknown name)', md={}):
Am Freitag, den 13.05.2005, 23:42 -0700 schrieb Greg Fischer:
http://dev.mysql.com/doc/mysql/en/numeric-type-overview.html
That's it right there! Before 5.0.3, they were unpacked, meaning
saved like a char. Now they are packed, fixed point numbers. This is
screwing up the python functions
I guess my quick fix wont work. Well, it fixes the fmt for decimals,
but there's more to the issue. Statistical summaries, total, sum dont
work either.
In my dtml-in I might have this:
dtml-var total-decimalcolumn
or
dtml-var sum-decimalcolumn
These dont work with Mysql 5.0.4. So, what do we
Greg Fischer wrote:
I guess my quick fix wont work. Well, it fixes the fmt for decimals,
but there's more to the issue. Statistical summaries, total, sum dont
work either.
In my dtml-in I might have this:
dtml-var total-decimalcolumn
or
dtml-var sum-decimalcolumn
These dont work with Mysql
On 5/14/05, David H [EMAIL PROTECTED] wrote:
Greg,
Have you contacted the mySQL product maintainer? This is not a Zope
community issue. Which is to say, many of us have the instinct to help
but simply do not use mySQL and therefore have nothing to suggest.
Other than what is obvious:
a)
ok, lots of testing, and I have found that this is related to Mysql 5.0.4.
I compiled and installed Mysql 5.0.0 and the problem does not exist. I
guess means that it started in 5.0.1 or higher. I read through the
change logs and saw a couple of items related to float values on 5.0.3
and 5.0.4,
Hi all,
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.
I tried all kinds of things in mysql
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
On May 13, 2005, at 03:21, Greg Fischer wrote:
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?)
Yes, that is correct. Do not use it if you
Darn! That didnt fix it. I just setup python 2.3.4, setup Zope 2.7.6
again, along with mysql-python 1.2.0 and ZMySQLDA-2.0.9b3, and
fmt=dollars-and-cents will not display the data. Also, I tried just
using the c-style formatting: fmt=$%.2f and I have a different
issue, I get a Type Error -
On 5/12/05, Greg Fischer [EMAIL PROTECTED] wrote:
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
Oh, it is a decimal(15,2) column. (all of them are) Just thought I'd
mention everything too... Running Ubuntu 5.0.4, has the Python 2.4.1
package installed, but I have Python 2.3.4 compiled and installed
separately for Zope. Zope is compiled with the --with-python flag.
Just tried your
13 matches
Mail list logo