Actually, the solution was easier than that. I just replaced the "," in the answer with "�" and whenever I display it to the user, I switch it back to "," :-)
Thanks for all the help everyone. Michel "ben.salming" wrote: > 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) -- "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)
