[Zope] Calling zsql from a page template

Roy S. Rapoport zope@ols.inorganic.org
Sat, 19 Jul 2003 09:45:58 -0700


I'm missing some fairly basic syntax here, I'm sure, but the zsql chapter
seems to only cover DTML.  

zsql_movienames is a zsql method returning simply a 'Name' column and
requiring no arguments.  I'm calling it thus:
<table border="1" width="100%">
  <tr>
    <th>Movie name</th>
  </tr>
  <tr tal:repeat="item zsql_movienames">
    <td tal:content="item/Name">Some Movie Name</td>
   </tr>
</table>

But I'm getting 
Error Type: KeyError
Error Value: zsql_movienames

Any pointers to a doc that will cover what I'm trying to do? This is as
elementary as it gets ...

-roy