[Zope-DB] optional sql variables and commas

Dieter Maurer dieter@handshake.de
Sun, 1 Sep 2002 22:56:16 +0200


Michal Kurowski writes:
 > I'm having problems with following sql statement on mysql with 
 > MySQLpy-0.9.1:
 > 
 > update Users set
 > Organization=<dtml-sqlvar organization type=string optional>
 > Country=<dtml-sqlvar country type=string optional>
 > City=<dtml-sqlvar city type=string optional>,
 > Address=<dtml-sqlvar address type=string optional>
 > where Username=<dtml-sqlvar username type=string>
Someone published an extension to "dtml-sqlgroup" such that
is supports an additional "<dtml-comma>" in addition to
"<dtml-and>" and "<dtml-or>". Search for "dtml-comma".


Dieter