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!
Mark On Tue, Aug 24, 2010 at 9:48 AM, Garry Saddington < ga...@schoolteachers.co.uk> wrote: > Garry Saddington wrote: > > Andreas Jung wrote: > >> -----BEGIN PGP SIGNED MESSAGE----- > >> Hash: SHA1 > >> > >> I would assume that you can use DTML-IN for looping and generating > >> multiple SQL statements of the same kind. You have to ensure that > >> the statements having a proper delimiter (there was something in DTML?! > >> DTML-SQLDELIMITER?...no idea, you need to checks the docs of this > >> ancient technology). > > > oops: > <dtml-var sql_delimiter> > code in snippets is correct though. > sorry > Garry > > > Andreas is correct but the delimiter is <dtml-sql_delimiter>. > > Probably better to do this in python script, but here are some code > > snippets to help you: > > In the form: > > > > <select name="seasons:list" multiple="multiple"> > > > > In the ZSQL method: > > > > <dtml-in seasons> > > <dtml-var sql_delimiter> > > > > insert statement goes here, don't forget the ; at the end. > > > > </dtml-in> > > > > Hope this is of some help, others may want to chip in with other > > suggestions, such as doing the same in python. Anyway good luck. > > Garry > > _______________________________________________ > > Zope-DB mailing list > > Zope-DB@zope.org > > https://mail.zope.org/mailman/listinfo/zope-db > > > > _______________________________________________ > Zope-DB mailing list > Zope-DB@zope.org > https://mail.zope.org/mailman/listinfo/zope-db >
_______________________________________________ Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db