You&#39;re right but even with a WHERE statement I get the same programming error, I have to use the <span><span><span><span><span><span><span><span><span style="display: block;">dtml-sqlgroup statement<br><br></span></span></span></span></span></span></span></span></span><span><span><span><span><span></span></span></span></span></span><span><span><span><span><span><span><span></span></span></span></span></span></span></span>Françoise<br>
<br><div class="gmail_quote">2008/12/12 Andrew Milton <span dir="ltr">&lt;<a href="mailto:akm@theinternet.com.au">akm@theinternet.com.au</a>&gt;</span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
+-------[ Fran?oise CONIL ]----------------------<br>
<div class="Ih2E3d">| Trying :<br>
|<br>
| &nbsp; &nbsp; &nbsp; &nbsp; select * from mytable &lt;sqltest mylist multiple type=int column=id&gt;<br>
<br>
<br>
</div>select * from mytable WHERE &lt;sqltest mylist multiple type=int column=id&gt;<br>
 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;^^^^^<br>
<br>
Missed a where statement...<br>
<br>
| Thanks for your reply<br>
<br>
No problem.<br>
<font color="#888888"><br>
--<br>
Andrew Milton<br>
<a href="mailto:akm@theinternet.com.au">akm@theinternet.com.au</a><br>
</font></blockquote></div><br>