[Zope] external and sql methods

[Anthony Baxter]

>>> ainis wrote
> Is there any way to call sql method from external method?

Yep - assuming you pass the sql method itself to the external method as
'meth', and it's set up as:
arguments: 
   name
body of method:
   select accountid, groupid
   from account_table
   where
   name = <!--#sqlvar name type=string-->

then your ext. method could be like

def ext1(meth):
  res=meth(name="fred")
  for r in res:
     # here, you iterate through the list of results.
     # normally a result will simply be an instance of
     # a dumb class with attributes set to the results,
     # eg:
     dosomethingwith(r.accountid, r.groupid)

hope this helps,
Anthony