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
