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

When I retrieve multiple values from a selection box, I need to create a loop somewhere to insert the multiple values (rows) into a table. Is there a way to do this within a ZSQL statement, or is it best to do the looping in a Python script? My specific example table 1 (Players) has informati

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

-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 check

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

Zope-DB mailing list Zope-DB@zope.org https://mail.zope.org/mailman/listinfo/zope-db __ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 5393 (20100824) __ E-Mail wurde geprüft mit ESET NOD32 Antivirus. http://www.eset.com __ Hinweis von ESET

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

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-SQLDELIM

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

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 some

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

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: >

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

- Puvodní zpráva - Od: "Andreas Jung" > -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 somet

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

On 08/24/2010 04:04 PM, Jaroslav Lukesh wrote: > ZPT is more academic platform, than for everyday usage. Wow, I have never heard that opinion before. I have had quite the opposite experience: I find ZPT more productive and less error-prone than all other web templating languages. I have a proj

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

- Puvodní zpráva - Od: "Shane Hathaway" > On 08/24/2010 04:04 PM, Jaroslav Lukesh wrote: >> ZPT is more academic platform, than for everyday usage. > > Wow, I have never heard that opinion before. I have had quite the > opposite experience: I find ZPT more productive and less error-pro

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

2010/8/25 Jaroslav Lukesh > > - Puvodní zpráva - Od: "Andreas Jung" > > > > -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 ha