[Zope-DB] Calling a Z SQL method using a previous returned values

[Jason Walsh]

Hi ,

I have the following ZPT code

<span tal:repeat="rowos here/sqlMethod1">
  <tr tal:repeat="row python:here.sqlMethod2(id = rowos/os_id)">
    <td><tal:content="row/os_name"></td>
  </tr>
</span>

What I want to do is use the results from the first sqlMethod as a parameter
to the second to get a string that should be displayed.  The problem is that
it says it does not know the variable os_id which is in the table that the
first sql method called.

Can anybody help?

Thanks.