[Zope-DB] ZSQL Question - Insert multiple rows in one statement?

[Mark Phillips]

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 <
garry at 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 at zope.org
> > https://mail.zope.org/mailman/listinfo/zope-db
> >
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> https://mail.zope.org/mailman/listinfo/zope-db
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope-db/attachments/20100824/b6c8877d/attachment.html