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 )
