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