This may be a stupid suggestion but why not use an "answercodes" table. That way the values that your checkboxes hold are codes that can be related to the answercodes table - no need to worry about commas in your checkbox values.
Karl > From: Michel Rouse <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 19 Mar 2002 13:35:20 -0500 > To: [EMAIL PROTECTED] > Subject: Re: [CFTALKTor] Multiple answers > > Perhaps I can better explain myself. > > I am building a form from a database of questions and answers. The goal is to > make this as flexible as possible (least amount of restrictions as possible > such > as "no commas allowed") > > Example: > > ID Ques Ans > 1 Favorite Colors beige;white;green > 2 What Season spring, when it's cold;spring, when it's hot;summer, > when it's cloudy;summer, when it's sunny > > Now, my form would have the following: > <form... > Favorite Colors:<br> > <input type="checkbox" name="1" value="blue"><br> > <input type="checkbox" name="1" value="orange"><br> > <input type="checkbox" name="1" value="black"><br> > <p>What Season:<br> > <input type="checkbox" name="2" value="spring, when it's cold"><br> > <input type="checkbox" name="2" value="spring, when it's hot"><br> > <input type="checkbox" name="2" value="summer, when it's cloudy"><br> > <input type="checkbox" name="2" value="summer, when it's sunny"> > </form> > > On the processing page I would like to be able to use FORM.1 and FORM.2 as a > list. Since FORM.1 has no commas in it, I would have a list of 3 elements > (blue,white,green). However, FORM.2 would give me a list of 8 elements when > in > reality it should be 4 elements. > > Hope this clarifies it a little, > Michel > > Michel Rouse wrote: > >> I am having trouble with a form I am creating. >> >> If I use a check boxes to capture the data, it will create a list of >> values seperated by commas. For example, a user checks off three boxes >> 1: blue; 2: orange; 3: white. As a result, FORM.color = >> blue,orange,white. This is fine except if my options were 1: >> blue,purple; 2: orange; 3: white. Here, FORM.color = >> blue,purple,orange,white which means I have 4 answers even though the >> user only selected three anwsers. I would like to be able to seperate >> the items but I'm not sure how. >> >> Ideally, I would like to have FORM.color = >> "blue,purple","orange","white". >> >> Perhaps the answer lies in doing something to the answers before they >> get passed to the form processing page. Something to indicate that the >> , in blue,purple is just plain text and not a delimiter for the evenual >> list. >> >> Any help would be appreciated, >> Michel >> >> -- >> "Put your hand on a hot stove for a minute, and it seems like >> an hour. Sit with a pretty girl for an hour, and it seems like >> a minute. That's relativity." >> >> -- Einstein, Albert >> _______________________ >> >> Michel Anthony Rouse >> Webmaster >> Steltor >> >> 2000 Peel street, 4th floor >> Montreal, Quebec >> H3A 2W5 >> Canada >> >> tel: +1 (514) 733-8500 x-5001 >> fax: +1 (514) 733-8878 >> [EMAIL PROTECTED] >> www.steltor.com >> >> Toll free in North America: 1-800-675-2991 >> >> - >> You are subscribed to the CFUGToronto CFTALK ListSRV. >> This message has been posted by: Michel Rouse <[EMAIL PROTECTED]> >> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ >> Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ >> This System has been donated by Infopreneur, Inc. >> (http://www.infopreneur.net) > > -- > "Put your hand on a hot stove for a minute, and it seems like > an hour. Sit with a pretty girl for an hour, and it seems like > a minute. That's relativity." > > -- Einstein, Albert > _______________________ > > Michel Anthony Rouse > Webmaster > Steltor > > 2000 Peel street, 4th floor > Montreal, Quebec > H3A 2W5 > Canada > > tel: +1 (514) 733-8500 x-5001 > fax: +1 (514) 733-8878 > [EMAIL PROTECTED] > www.steltor.com > > Toll free in North America: 1-800-675-2991 > > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: Michel Rouse <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ > This System has been donated by Infopreneur, Inc. > (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: Karl Zarudny <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
