first, convert mylist to string before calling ZSQL method: <dtml-call "REQUEST.set('strmylist', _.str(mylist))"> And then call the ZSQL method: <params> strmylist:string="[0]" </params> SELECT * FROM MyTable WHERE id in (<dtml-var "strmylist[1:-1]" sql_quote>) ----- Original Message ----- From: Françoise CONIL To: zope@zope.org Sent: Thursday, December 11, 2008 11:21 AM Subject: [Zope] Problem using dtml-in in ZSQL method Hello, My ZSQL method receive a *mylist* parameter that should be an integer list : [21,35] The following code does not work : SELECT * FROM MyTable WHERE id in (<dtml-in mylist> <dtml-sqlvar sequence-item type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Type de l'erreur* NameError *Valeur de l'erreur* 'client' may not be used as an argument name in this context This other code does not work better : SELECT * FROM MyTable WHERE id in (<dtml-in mylist prefix="myid"> <dtml-sqlvar expr="myid_item" type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) *Same error* However, if I use a dictionary list of this type [{'id':21},{'id':35}] with the following code, it works (but it's heavy) SELECT * FROM MyTable WHERE id in (<dtml-in mylist mapping> <dtml-sqlvar id type=int> <dtml-if sequence-last><dtml-else>,</dtml-if> </dtml-in>) The python script that calls my ZSQL method has already build the integer list and I would like to use it as is. Thanks for your help _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )