Trying :<br><br> select * from mytable <sqltest mylist multiple type=int column=id> <br><br>did not work, it generates a ProgrammingError<ul><li> Module Shared.DC.ZRDB.DA, line 374, in __call__</li><li> Module Products.ZMySQLDA.db, line 273, in query</li>
</ul>ProgrammingError: (1064, "You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version for the
right syntax to use near '<sqltest mylist multiple type=int
column=id> LIMIT 1000'")
<br><br>My problem was that I tried to test my Z SQL method through the ZMI, testing with a python script worked fine with the following Z SQL method :<br><span class="ul-threaded" style="margin: 0.5em 0pt 0pt -15px;"><span class="connect"><span id="li1642691" class="li-threaded"><span id="ul1642691" class="ul-threaded"><span class="connect connect-end"><span id="li1643334" class="li-threaded"><span class="threaded"><span class="post-middle"><span id="post1643334" style="display: block;">SELECT *
<br>FROM MyTable
<br><dtml-sqlgroup where>
<br> <dtml-sqltest mylist column=id type=int multiple>
<br></dtml-sqlgroup>
</span></span></span></span></span></span></span></span></span><span class="ul-threaded" style="margin: 0.5em 0pt 0pt -15px;"><span class="connect"><span id="li1642691" class="li-threaded"><span id="ul1642691" class="ul-threaded"><span class="connect connect-end"><span id="li1643334" class="li-threaded"><span class="threaded"><span class="post-middle"><span id="post1643334" style="display: block;">I also modified the "mylist" parameter declaration to specify that it is a list of integers which is set to none if no parameter is passed.
<br><br> liste:list:int=none
</span></span></span></span></span></span></span></span></span><br>Thanks for your reply<br>