[Zope] Checkbox form data storage was (Help with expr)

[Eric Walstad]

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&nbsp;&nbsp;
> <input type="checkbox" name="membership" value="A"> AMG&nbsp;&nbsp;
> <input type="checkbox" name="membership" value="E"> EXCIMS&nbsp;&nbsp;
> <input type="checkbox" name="membership" value="M"> MSWG&nbsp;&nbsp;<br>
> <input type="checkbox" name="membership" value="V"> VV&amp;A
> TWG&nbsp;&nbsp;
> <input type="checkbox" name="membership" value="T"> VV&amp;A
> TST&nbsp;&nbsp;
> <input type="checkbox" name="membership" value="I"> MSTWG&nbsp;&nbsp;
>
> 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
>
>