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

Steve Drees drees@the-bridge.net
Mon, 2 Apr 2001 10:06:14 -0500


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

<dtml-var sql_delimiter> works much better