Why does this not work inside a Z SQL Method (using MySQL) ?!

INSERT INTO test1
( id, content, phone )
VALUES (
<dtml-var 12.12>,
<dtml-sqlvar content type=nb>,
<dtml-sqlvar phone type=nb optional>
)

According to the doc I should be able to use dtml-var statements in Z SQL
Methods. However, this returns an error: Error, exceptions.KeyError: 12.12

I also tried:
INSERT INTO test1
( id, content, phone )
VALUES (
<dtml-sqlvar id type=float>,
<dtml-sqlvar content type=nb>,
<dtml-sqlvar phone type=nb optional>
)

This also retuns an error: Error, exceptions.ValueError: Invalid
floating-point value for id

But it is no problem inserting data by hand into the database using the very
same value as I used in these tests (12.12).

What am I doing wrong ?

Gijs Reulen


_______________________________________________
Zope maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )

Reply via email to