redesign your database so that each answer, regardless of 'answer' is represented by an ID.
<input type="checkbox" name="1" value="1"><br> <input type="checkbox" name="1" value="2"><br> <input type="checkbox" name="1" value="3"><br> <p>What Season:<br> <input type="checkbox" name="2" value="3"><br> <input type="checkbox" name="2" value="4"><br> <input type="checkbox" name="2" value="5"><br> <input type="checkbox" name="2" value="6"> more work initiately but infinitely more usable, expandable, editable, etc.... Ben ----- Original Message ----- From: "Karl Zarudny" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 19, 2002 2:12 PM Subject: Re: [CFTALKTor] Multiple answers > 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) > - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "ben.salming" <[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)
