[Zope-DB] Insert Date in dtml-sqlvar

Julián Muñoz jmunoz@telefonica.net
Fri, 3 May 2002 08:12:35 +0000 (GMT)

On 3 May 2002, Frank Tegtmeyer wrote:

> Julián Muñoz <jmunoz@softhome.net> writes:
> > Note: really, I don't understand why this works, it's metaphysics.
> > Maybe someone could explain ??
> This depends on the used database, I think. Andy Dustman told me that
> the ZSQL adapter just passes the dat/time/datetime arguments unchanged
> to the database. MySQL accepts strings in ISO format that's why
> <dtml-var xxx fmt="ISO"> works.

Thank you very much,

 { ts '<dtml-var FromDate fmt=ISO sql_quote>'}

but what means { ts 'xxxx' } in a zsql method ??

> I was surprised by that because the other way (from MySQL to Zope)
> converts date/time/datetime values to DateTime objects if mxDateTime
> is available. Of course I expected that I can give DateTime objects to
> update methods too :)

Yes :-)


    _ \<_

Saludos de Julián

Foro Wireless Madrid