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

Eric Walstad eric@walstads.net
Fri, 10 Aug 2001 11:48:40 -0700


Hi Todd,
I'm under a project deadline crunch here and don't have the time right now
to help more, sorry.
To get you up and running, try using something like:

INSERT INTO (your_string_field)
VALUES ("<dtml-var expr="_.string.join(your_check_box_list, ',')">");

**DISCLAIMER**
This is a hack (probably unsafe, use with caution), but it might help you
get rolling.

Good Luck,

Eric.

> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Todd
> Loomis
> Sent: Friday, August 10, 2001 11:11 AM
> To: zope@zope.org
> Subject: RE: [Zope] Checkbox form data storage was (Help with expr)
>
>
> Where should I put this. I put in my SOL method and get problems:
>
> <dtml-in yourlist>
> <dtml-unless sequence-start>,</dtml-unless>
> <dtml-sqlvar sequence-item type=int>
> </dtml-in>
>
> If i select 2 checkboxes one goes into the database correct the
> other gets
> added to the next field.
>
> Todd
>
> At 10:40 AM 8/10/2001 -0700, you wrote:
> >Oh, I just noticed that Tino W. posted a better solution to
> Charlene.  You
> >might want to have a look at that one.  -E
> >
> > > -----Original Message-----
> > > From: Eric Walstad [mailto:eric@walstads.net]
> > > Sent: Friday, August 10, 2001 10:36 AM
> > > To: zope@zope.org; Todd Loomis
> > > Subject: RE: [Zope] Checkbox form data storage was (Help with expr)
> > >
> > >
> > > Hi Todd,
> > > Please keep this thread on the mailing list...
> > >
> > > > I have one column named membership type varchar(30)
> > > OK.  I'm assuming that the field has values like:
> > > "D,A,M,I,T" (heehee, couldn't resist :)
> > >
> > > If so, you will need to convert the list of strings in the
> > > "membership" REQUEST variable to a string of comma separated
> > > values before you update your database with a ZSQL Method.
> > >
> > > Hint: read about Python's string.join() function (accessible in
> > > DTML with <dtml-var expr="_.string.join()">)
> > >
> > > Eric.
>
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> 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
>
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )