[Zope] Is there a <dtml-comma> for SQL UPDATEs?
Guy Davis
davis@arc.ab.ca
Thu, 13 Jan 2000 16:10:10 -0700
I now have all my insert and select queries working, but am having
trouble with an UPDATE.
For the query:
UPDATE users
SET
<dtml-sqlgroup>
<dtml-sqltest login type=nb optional>
<dtml-sqltest email type=nb optional>
</dtml-sqlgroup>
WHERE <dtml-sqltest userid type=int>
This works perfectly except when both login and email are provided
because the query becomes:
UPDATE users
SET login='a_login'
email='an_email'
WHERE id=1
Without the comma between the login and email, it doesn't work. I loved
the <dtml-and> and <dtml-or> tags for SELECT statements. I tried a
<dtml-comma> but no such luck. Does this exist or do I need to use
separate UPDATE statements for each column, each wrapped in a
<dtml-if>?
Thanks.
--
Guy Davis mailto:davis@arc.ab.ca
(403) 210-5334 Alberta Research Council