[Zope] Is there a <dtml-comma> for SQL UPDATEs?
David Salgado
David@connmed.co.uk
Fri, 14 Jan 2000 11:27:25 -0000
>Hmmm.... AFAIK, there's no such animal as <dtml-comma>. But without
>much research on the matter, I'd say that this'd do it:
>
>UPDATE
> users
>SET
> <dtml-sqlgroup>
> <dtml-sqltest login type=nb optional>
> <dtml-if email>,<dtml-sqltest email type=nb optional></dtml-if>
> </dtml-sqlgroup>
>WHERE
> <dtml-sqltest userid type=int>
>
Any ideas on how to do this without hard-coding the field names into the
ZSQL method? I'm trying to use a property which defines a list of fields,
and then my editing/listing interface can be generic for a whole bunch of
record types, acquiring the list of fields to decide what to display/update.
Actually, I guess my question boils down to 'how do I remove a trailing
comma from a string in a ZSQL method?' -- any ideas?
Cheers
David