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

[Gitte Wange]

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
************************