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:
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:
or
These dont work with Mysql 5.0.4. So, what do we have to change in
the Mysql DA or may
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:
or
These dont work with Mysql 5.0.4. So, what do we have to change in
the Mysql DA or maybe the Mysql-python
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 function
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={}):
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 li
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, bu
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 suggesti
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.
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 - f
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 expec
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 no
On 5/12/05, Greg Fischer <[EMAIL PROTECTED]> 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 op
13 matches
Mail list logo