Re: [Zope] external and sql methods

4 Aug 1999

      ...
...
...
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

Anthony Baxter

tags

participants (1)