[Zope-DB] Re: Easier updates with <dtml-sqlgroup set> and <dtml-comma>?

Jeff Kowalczyk jtk@yahoo.com
Tue, 19 Nov 2002 13:01:28 -0500


Well, that's about as 'doctor-ordered' as you can get! Thanks for the reference to the
sql-blender patch for sql-group.py.

It's probably a sign that a patch should aspire to be in the core if a zsql-newbie wishes
for an api out of the blue and the verbatim match already exists. Who to ask about
applying that diff to sqlgroup.py for future Zope releases? (AFAICT the Aqueduct.py diff
is unnecessary for this particular purpose, and the sqlgroup patch seems pretty harmless)

update Shipments
<dtml-sqlgroup set noparens>
  <dtml-sqltest ShipperInvoiceID type="nb" op="eq" optional>
  <dtml-comma>
  <dtml-sqltest ShipperChargeAsBilled type="float" op="eq" optional>
  <dtml-comma>
  <dtml-sqltest ShipperChargeAsPaid type="float" op="eq" optional>
</dtml-sqlgroup>
where ShipmentID = <dtml-sqlvar ShipmentID type="nb">


"Ben Avery" <ben@thesite.org> wrote in message news:3DDA6FFE.4050805@thesite.org...
> the product below has a couple of patches to the sqlgroup source code,
> which allows you to do exactly what you're looking for, and which has
> saved me already!