[Zope] DTML-sqltest question

Dieter Maurer dieter@handshake.de
Tue, 26 Jun 2001 23:38:11 +0200 (CEST)


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