You can try putting a ; after the lines i.e. Update <table> set <field>=<dmtl data> where <field>=<dtml data>; Update <table> set <field>=<dmtl data> where <field>=<dtml data> HTH Laurie -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Gitte Wange Sent: Monday, April 02, 2001 8:25 AM To: zope@zope.org Subject: [Zope] Updating multiple fields in the same Z SQL Method How do you update several fields in the same SQL method ? I just entered something like this: Update <table> set <field>=<dmtl data> where <field>=<dtml data> Update <table> set <field>=<dmtl data> where <field>=<dtml data> But I get an error because Zope just sees it as a whole line. How do I seperate them ? Regards, -- ************************ Gitte Wange Jensen System Squid Developer MMManager Aps +45 29 72 79 72 gitte@mmmanager.org ************************ _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )