[Zope] mySQL - Z SQL - dtml-var

[Dieter Maurer]

Gijs Reulen writes:
 > 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
This is indeed a strange variable name (12.12).

Do you mean the floating point value 12.12 rather than a variable of
this name?

In this case, you should use:
  <dtml-var "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
Obviously, "id" does not contain a floating point value.



Dieter