 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / January 2007I'm phuxored (complete ASP n00b) - Multiple checkboxes on a form?
I apologize for being a total n00b here, I'm pretty good with Access so I understand some of the theory but I know little to nothing about ASP. I want to create a form. On the form will be a question, something like, "Which cars are your favorites?" I want to put several checkboxes on the form and allow as many selections as they want to check off. I also want to put a text box where the user can leave comments, and another where the put their name. What's the best way to set up a table(s) so that I can store individual responses to the form? How do I write the code if I'm going to do this in ASP with an Access back end? Any help would be appreciated. >I apologize for being a total n00b here, I'm pretty good with Access so > I understand some of the theory but I know little to nothing about ASP. [quoted text clipped - 11 lines] > responses to the form? How do I write the code if I'm going to do this > in ASP with an Access back end? Any help would be appreciated. First, you will need to know enough about ASP and ADO so that you can connect to a database and perform an insert operation. You will also need to understand how an html form passes values either using POST or GET. Finally, you will need to know how to retrieve the values from the posted form. www.w3schools.com/asp and www.w3schools.com/ado will get you started. Another very good tutorial series can be found here: http://msconline.maconstate.edu/tutorials/ASP/default.htm -- Mike Brind Well, I've done simple stuff connecting to DBs and spitting info out. I just need to kno whow to store the value of a bunch of checkboxes and keep it so that if more checkboxes are added in the future I can do it through a table or something instead of having to edit the code. > >I apologize for being a total n00b here, I'm pretty good with Access so > > I understand some of the theory but I know little to nothing about ASP. [quoted text clipped - 24 lines] > -- > Mike Brind >> >I apologize for being a total n00b here, I'm pretty good with Access so >> > I understand some of the theory but I know little to nothing about ASP. [quoted text clipped - 27 lines] > keep it so that if more checkboxes are added in the future I can do it > through a table or something instead of having to edit the code. I'm not sure I understand what you mean by "how to store the value of a bunch of checkboxes". Do you mean how to insert a bunch of values in a database? If so, you use an Insert statement. In terms of how you structure your table, that depends on what kind of information you want to get out of it at the end. -- Mike Brind Can you give me an example of the proper insert statement if I had 3 checkboxes on a form, chk1, chk2 and chk3? > I'm not sure I understand what you mean by "how to store the value of a > bunch of checkboxes". Do you mean how to insert a bunch of values in a [quoted text clipped - 5 lines] > -- > Mike Brind OK. The SQL will depend on how you structure your table. I guess at the moment, you don't know the answer to that. Let's say you have a question "Which of the following colours do you like?" And you have a set of checkboxes representing the colour choices: <input type="checkbox" name="colour" value="red"> Red <br> <input type="checkbox" name="colour" value="red"> Red <br> <input type="checkbox" name="colour" value="red"> Red <br> <input type="checkbox" name="colour" value="red"> Red <br> <input type="checkbox" name="colour" value="red"> Red <br> > Can you give me an example of the proper insert statement if I had 3 > checkboxes on a form, chk1, chk2 and chk3? [quoted text clipped - 8 lines] >> -- >> Mike Brind Sorry about that - copying and pasting sent my post somehow.... Where was I? Oh yes... OK. The SQL will depend on how you structure your table. I guess at the moment, you don't know the answer to that. Let's say you have a question "Q1. Which of the following colours do you like?" And you have a set of checkboxes representing the colour choices: <input type="checkbox" name="Q1" value="red"> Red <br> <input type="checkbox" name="Q1" value="blue"> Blue<br> <input type="checkbox" name="Q1" value="green"> Green<br> <input type="checkbox" name="Q1" value="brown"> Brown<br> <input type="checkbox" name="Q1" value="orange"> Orange<br> Because we gave the same name to each of the checkboxes, this grouped them, and any values will be sent as a comma-separated string, so when someone ticks Red and Green, what gets passed in the Request collection is a name/value pair is: name = Q1 value = Red,Green If you are happy to store "Red,Green" in the field for Q1, then the Insert statement is straightforward: Insert into Questions (Q1) Values ('" & Request.Form("Q1") & "') However, if the person answering the questions missed Q1, then Request.Form("Q1") will not exist. Checkbox values are only passed if they are selected. You can test the length of the value to see if there is anything there: If Len(Request.Form("Q1")) = 0 'then you know it wasn't answered. You need to think a bit more about what information you want to store then have a go at doing it. If and when you run into problems or get error messages, come back with the code you tried and a description of the problem. -- Mike Brind > Can you give me an example of the proper insert statement if I had 3 > checkboxes on a form, chk1, chk2 and chk3? [quoted text clipped - 8 lines] >> -- >> Mike Brind |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.