Re: [Zope] Problem using dtml-in in ZSQL method

11 Dec 2008


      | ----- 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>)

select * from mytable
<dtml-sqlgroup where>
<dtml-sqltest mylist multiple type=int>
</dtml-sqlgroup>

-- 
Andrew Milton
akm@theinternet.com.au