Hi Todd, I'm moving this over to the mailing list in case other's want to join in fun :) Does your database table have *one* string field named "membership" or are there many boolean fields that represent the different memberships that each user record can have? Depending on that answer, you will need to use a different method to store the checkbox data in your database. When your form is submitted, Zope will interpret your check boxes as a list of string values. You can verify this by posting your form to a DTML method that includes: <dtml-var REQUEST> and looking at the form variables. That list represents the items checked in your form. In your ZSQL Method you can use the <dtml-sqlgroup> , <dtml-sqlvar> and <dtml-sqltest> tags to dynamically build your SQL string. Have a look at the "Passing Parameters to Scripts" and "Dynamic SQL Queries" sections of the Zope Book. There are a lot of great examples there. Good luck, Eric.

-----Original Message----- From: Todd Loomis [mailto:tloomis@dmso.mil] Sent: Friday, August 10, 2001 8:45 AM To: eric@walstads.net Subject: RE: [Zope] Help with expr

Eric:

I have a set of check boxes that can be checked if the person is a member. My problem is if I pick more than one membership nothing goes into the database. So when bring the record up to view or edit I get no boxes checked even if they should be, here's my codes:

Form: <input type="checkbox" name="membership" value="D"> DMSO   <input type="checkbox" name="membership" value="A"> AMG   <input type="checkbox" name="membership" value="E"> EXCIMS   <input type="checkbox" name="membership" value="M"> MSWG  <br> <input type="checkbox" name="membership" value="V"> VV&A TWG   <input type="checkbox" name="membership" value="T"> VV&A TST   <input type="checkbox" name="membership" value="I"> MSTWG  

SQL: <dtml-var membership type="string">

Todd

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Todd Loomis Web Developer (SAIC) Defense Modeling & Simulation Office 1901 N. Beauregard Street, Suite 500 Alexandria, VA 22311 Office: 703.824.3407 Fax: 703.379.3778 tloomis@dmso.mil