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

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