Thanks, this idea worked perfectly for me. -Laura -----Original Message----- From: Thierry FLORAC [mailto:tflorac@onf.fr] Sent: Tuesday, October 19, 2004 11:19 AM To: Laura McCord Cc: zope@zope.org Subject: Re: [Zope] Calling a zsql with optional fields Hi, I think that I already made this kind of thing working with a simple : <dtml-in "findResults(REQUEST.form)"> ... </dtml-in> (if "findResults" is the name of your ZSQLMethod component...) Thierry On Tue, 2004-10-19 at 18:11, Laura McCord wrote: 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. _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope <http://mail.zope.org/mailman/listinfo/zope> ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce <http://mail.zope.org/mailman/listinfo/zope-announce> http://mail.zope.org/mailman/listinfo/zope-dev <http://mail.zope.org/mailman/listinfo/zope-dev> )