[Zope] Updating multiple fields in the same Z SQL Method

[Laurie Nason]

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 )