[Zope] [NEWBIE] Unambiguous expressions in Z SQL methods

[Dieter Maurer]

Biju Chacko writes:
 > I created a Z SQL Method called listFoo thus:
 > 
 > -8<------
 > 
 > Parameter: foo.code
 > 
 > SELECT foo.*, bar.desc
 > FROM foo
 >     INNER JOIN bar ON foo.bar = bar.code
 > <dtml-sqlgroup where>
 >     <dtml-sqltest foo.code op="eq" type="int">
 > </dtml-sqlgroup>

Use simple names (valid as Python names) as parameters.
You can use the "column" attribute of "dtml-sql*" tags
to use different column names for the generated SQL.


Dieter