[Zope] MySQL timestamp issue

[Hugo Ramos]

Yellow,

I wrote the wrong version.
I'm using MySQL 4.0.24 + Zope 276 + mysql-python 1.0.0 + ZMySQLDA 2.0.9b3

This is the DTML code generating the error:
<dtml-var docdataemissao fmt="%Y-%m-%d">

docdataemissao is a timestamp field in a table like:
200406011023

The traceback:
Error Type: ValueError
Error Value: unsupported format character 'Y' (0x59) at index 1

[...]
Module DocumentTemplate.DT_String, line 474, in __call__ 
Module DocumentTemplate.DT_In, line 703, in renderwob 
Module DocumentTemplate.DT_Var, line 280, in render
__traceback_info__: ('docdataemissao', <DateTime object for
'2005-06-01 12:34:45.00' at 19878e0>, {'': 'docdataemissao', 'fmt':
'%Y-%m-%d'})

Any ideas???


Cheers
Hugo



On 6/3/05, Andy Dustman <farcepest at gmail.com> wrote:
> On 6/3/05, Hugo Ramos <ramosh at gmail.com> wrote:
> > I already know what exactly makes Zope hang!
> > The problem is located at times.py that was installed by MySQL-Python
> > 1.2.0 (MySQL-python.exe-1.2.0.win32-py2.4.zip)
> 
> This is a package for Python-2.4. Are you using Python-2.4 with
> Zope-2.7? If you are, the line of people prepared to yell at you is
> long and distinquished.
> 
> What version of ZMySQLDA are you using? Only 2.0.9b3 will work
> properly with MySQLdb-1.2.0.
> --
> Computer interfaces should never be made of meat.
> http://www.terrybisson.com/meat.html
> 


-- 
Hugo Ramos - ramosh at gmail.com