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