Thanks everyone for their help. I decided to do the looping in the Python Controller Script instead of dtml...much easier and faster to put it together!<br><br>Mark<br><br><div class="gmail_quote">On Tue, Aug 24, 2010 at 9:48 AM, Garry Saddington <span dir="ltr"><<a href="mailto:garry@schoolteachers.co.uk">garry@schoolteachers.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div class="im">Garry Saddington wrote:<br>
> Andreas Jung wrote:<br>
>> -----BEGIN PGP SIGNED MESSAGE-----<br>
>> Hash: SHA1<br>
>><br>
>> I would assume that you can use DTML-IN for looping and generating<br>
>> multiple SQL statements of the same kind. You have to ensure that<br>
>> the statements having a proper delimiter (there was something in DTML?!<br>
>> DTML-SQLDELIMITER?...no idea, you need to checks the docs of this<br>
>> ancient technology).<br>
><br>
</div>oops:<br>
<dtml-var sql_delimiter><br>
code in snippets is correct though.<br>
sorry<br>
<font color="#888888">Garry<br>
</font><div class="im"><br>
> Andreas is correct but the delimiter is <dtml-sql_delimiter>.<br>
> Probably better to do this in python script, but here are some code<br>
> snippets to help you:<br>
> In the form:<br>
><br>
> <select name="seasons:list" multiple="multiple"><br>
><br>
> In the ZSQL method:<br>
><br>
> <dtml-in seasons><br>
> <dtml-var sql_delimiter><br>
><br>
> insert statement goes here, don't forget the ; at the end.<br>
><br>
> </dtml-in><br>
><br>
> Hope this is of some help, others may want to chip in with other<br>
> suggestions, such as doing the same in python. Anyway good luck.<br>
> Garry<br>
</div><div><div></div><div class="h5">> _______________________________________________<br>
> Zope-DB mailing list<br>
> <a href="mailto:Zope-DB@zope.org">Zope-DB@zope.org</a><br>
> <a href="https://mail.zope.org/mailman/listinfo/zope-db" target="_blank">https://mail.zope.org/mailman/listinfo/zope-db</a><br>
><br>
<br>
_______________________________________________<br>
Zope-DB mailing list<br>
<a href="mailto:Zope-DB@zope.org">Zope-DB@zope.org</a><br>
<a href="https://mail.zope.org/mailman/listinfo/zope-db" target="_blank">https://mail.zope.org/mailman/listinfo/zope-db</a><br>
</div></div></blockquote></div><br>