Re: [Zope] DTML-sqltest question

Stanislav Marszalek writes:

When I call ZSQL method with parameter ar=qname it doesnt find anything. When I test the ZSQL Method manualy and enter list (e.g. 'area1','area2') of values for "ar" it renders sql as select * from opps1 where ar = '\'area1\',\'area2\''

but according manual I expect(and need) select * from opps1 where ar in ('area1','area2')

I have tried this a several times with different values as input but was unsuccesfull to force zope to use "in ()" statement. Instead it takes input as string. How should the Z SQL method know that the value should be a list? Did you specify a ":list" suffix for the argument?

Dieter