[Zope] multiple records update

Mike Doanh Tran mtran at shufflemasterrd.com
Tue Oct 14 14:02:59 EDT 2003


Howdy,

I am trying to update multiple customers records on the same page.  I put 
individual customer records into lists.  For example, I have four lists:

field1: ['a','b','c','d'}
field2: ['a2','b2','c2','d2']
field3: ['a3','b3','c3','d3']
Cust_ID: ['1','2','3','4']

How do i break these list down so that i can pass it to a ZSQL method to 
udpate this:

UPDATE customers SET
field1=a,
field2=a2,
field3=a3,
where  Cust_ID=1

Then interate until the end of each list where Cust_ID=4

Is this possible to do in DTML?  Thanks in advance for any suggestions,

Mike  




More information about the Zope mailing list