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

2010-08-24 Thread Mark Phillips
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

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

2010-08-24 Thread 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 something in DTML?! DTML-SQLDELIMITER?...no idea, you need to

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

2010-08-24 Thread Sascha Gottfried
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 NOD32 Antivirus

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

2010-08-24 Thread Garry Saddington
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?!

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

2010-08-24 Thread Garry Saddington
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

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

2010-08-24 Thread 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 ga...@schoolteachers.co.uk wrote: Garry Saddington wrote: Andreas Jung wrote:

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

2010-08-24 Thread Jaroslav Lukesh
- Puvodní zpráva - Od: Andreas Jung li...@zopyx.com -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

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

2010-08-24 Thread 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-prone than all other web templating languages. I have a