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