[Zope] Re: dtml-with and dtml-sqltest

alan runyan runyaga@thisbox.com
Thu, 29 Mar 2001 22:59:34 -0600


Lee,

the zope mailing list is more appropriate for ZOPE inquiries.  there is a
larger community focused solely on that domain.  please direct email to
zope@zope.org.  I dont really know what sqltest does, I have never used it.

you can try this:

sqlMethod -
arguement - aaa=1
SELECT * FROM table WHERE id=<dtml-sqlvar aaa type="int">

dtmlMethod:

<dtml-let aaalist="[1,2,3]">
<dtml-in aaalist>
 <dtml-call "REQUEST.set('aaa', _['sequence-item'])">
 <dtml-in getPhById>
  <dtml-var PH>
 </dtml-in>
</dtml-in>
</dtml-let>


the dtmlMethod should probably be in a PythonMethod that looks like:

aaalist=[1,2,3]
stuff = []

for aaa in aaalist:
    for sql in container.getPhById({'aaa': aaa}): # _TRICKY_ ZSQLMethods *DO
NOT* use DTML namespace
       stuff.append(sql[0])                       # position in sql row
returned

return stuff


Lessons learned: PythonMethods are cleaner (on a whole), ZSQL doesnt get a
DTML namespace, Dieter Maurer has most of the answers on the ZOPE mailing
list, just search through it @ egroups.

~runyaga