[Zope] calling a SQL method without arguments

Larry Luther l.luther@acm.org
Thu, 10 Jun 1999 00:32:06 -0700


This SQL method takes two arguments "types" and "orderby".
In the calling form I allow the arguments to be initialized with ""
to indicate no selection.

SELECT * FROM Technologies
<!--#if types-->
  WHERE type IN (<!--#var types-->)   <<<< Work in progress, (one value)
<!--#/if-->
<!--#if orderby-->
  ORDER BY <!--#sqlvar orderby type=int-->, 1
<!--#else-->
  ORDER BY 1
<!--#/if-->

Larry