[Zope] Help with Nested ZSQL methods

Pavel V. Piankov pashah@cosmos-mebel.spb.ru
Wed, 29 Nov 2000 22:03:57 +0300


try calling like this : <dtml-in "sql_get_items(_.None,_)">
also you might what to use dmt-sql var instead of dtml-var inside ZAQL
Methods.


regards
--
pashah


>Here's the operative part of the dtml method that calls these methods:
>==============================================
><dtml-in sql_get_schedules>
>     <TABLE BORDER="3">
>     <TR><TH>Item No.</TH><TH>Description</TH><TH>Mn/DOT
>No.</TH><TH>Units</TH></TR>
>     <dtml-in sql_get_items>
>          <TR>
>               <TD><dtml-var ItemNo></TD>
>               <TD><dtml-var Description></TD>
>               <TD><dtml-var MnDOTNo></TD>
>               <TD><dtml-var UnitDescription></TD>
>         </TR>
>     <dtml-in>
>     <TABLE>
></dtml-in>
>==============================================
>
>I get the error:
>
>Error Type: Bad Request
>Error Value: ['SchedID']
>
>I suspect there is some type of namespace-related problem going on here
>where the var SchedID is not getting passed to the internal ZSQL method.
>
>P. Johnson