[Zope] Calling a zsql with optional fields

[Laura McCord]

Ok. I redesigned my zsql method to be much simpler:

 select * from host
 <dtml-sqlgroup where>
  <dtml-sqltest name="location1" column="site" type="nb" optional>
   <dtml-or>
    <dtml-sqltest name="location2" column="site" type="nb" optional>
   <dtml-or>
    <dtml-sqltest name="location3" column="site" type="nb" optional>
   <dtml-and>
  <dtml-sqlgroup>
   <dtml-sqltest name="usetype1" column="UseType" type="nb" optional>
   <dtml-or>
    <dtml-sqltest name="usetype2" column="UseType" type="nb" optional>
    <dtml-or>
     <dtml-sqltest name="usetype3" column="UseType" type="nb" optional>
   </dtml-sqlgroup>
  <dtml-and>
   <dtml-sqltest name="active" column="Active_Inactive" type="int"
optional>
</dtml-sqlgroup>

My form is a combination of checkboxes:
   <form action="resultsPage">
    <table>
    <tr>
    <td>Select any of the following combinations:</td>
    </tr>
    </table>
    <table>
    <tr>
    <td>Active:</td>
    <td><input type="checkbox" name="active" value="1"
checked="checked">Active</td>
    </tr>
    <tr>
    <td>Site:</td>
    <td><input type="checkbox" name="location1" value="aus">Austin </td>
    <td><input type="checkbox" name="location2"
value="ca">California</td>
    <td><input type="checkbox" name="location3"
value="mass">Massachusetts</td>    
    </tr>
    <tr>
    <td>UseType:</td>
    <td><input type="checkbox" name="usetype1"
value="server">Server</td>
    <td><input type="checkbox" name="usetype2" value="cad"> CAD</td>
    <td><input type="checkbox" name="usetype3" value="base">Base</td>
    </tr> 
    <tr>
    <td><span><input type="submit" class="submitLink"
value="save"></span></td>
    </tr>
    </table>
   </form>

The only problem I am having is bridging the two in order to get my
results. I have a dtml method that I am trying to process the zsql
method but I don't think I am doing it correctly.

<dtml-call expr="findResults(location1=location1, ...,
usetype1=usetype1, ...,active=active)">

 But, with the above if location2 or any of the boxes are not selected I
am getting an error that they are not defined. How do I correct this
problem?

Thanks You.