[Zope-DB] multiple table updates

Eric Kamm eric@analyticinnovations.com
Wed, 19 Mar 2003 12:04:55 -0600


Sorry, I didn't read that closely enough I think.

I would probably use ":records" to markup the form
variables so that I'd be starting with a list of
dictionaries back on the server. 

http://www.zope.org/Members/Zen/howto/FormVariableTypes

Then I'd put a <dtml-in> loop in my ZSQL method which
built the multiple SQL update statements which need to
be executed.

Alternatively, you could make a Python script which calls
a simpler ZSQL method (one which doesn't need to generate
multiple statements) for each record in the list.

Eric Kamm
Analytic Innovations, LLC
http://www.analyticinnovations.com



-----Original Message-----
From: zope-db-admin@zope.org [mailto:zope-db-admin@zope.org]On Behalf Of
Eric Kamm
Sent: Wednesday, March 19, 2003 11:56 AM
To: garry saddington; zope-db@zope.org
Subject: RE: [Zope-DB] multiple table updates


You can use <dtml-var sql_delimiter> to delimit multiple
SQL statements in your ZSQL method.

Eric Kamm
Analytic Innovations, LLC
http://www.analyticinnovations.com


-----Original Message-----
From: zope-db-admin@zope.org [mailto:zope-db-admin@zope.org]On Behalf Of
garry saddington
Sent: Wednesday, March 19, 2003 11:53 AM
To: zope-db@zope.org
Subject: [Zope-DB] multiple table updates


I have a form which retrieves data from a database table and displays it for 
the user to amend. Many records are able to be changed and i would then like 
to be able to update all these records in the table. I can not find a way to 
do this as yet. Can anyone help?
regards
garry saddington


_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db


_______________________________________________
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo/zope-db