Shouldn't this: <dtml-sqlvar sequence-item type=int> be <dtml-var sequence-item type=int> ?
-- Jeffrey D Peterson Webmaster Crary Industries, Inc. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Françoise CONIL Sent: Thursday, December 11, 2008 4:21 AM To: zope@zope.org 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 )
