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
participants (1)
-
Gijs Reulen