| Groups | Blog | Home |
inetserver asp db : I'm phuxored (complete ASP n00b) - Multiple checkboxes on a form?
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.
[quoted text, click to view] "ManningFan" <manningfan@gmail.com> wrote in message news:1169231568.206216.255150@a75g2000cwd.googlegroups.com... >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. > 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. [quoted text, click to view] Mike Brind wrote:
> "ManningFan" <manningfan@gmail.com> wrote in message > news:1169231568.206216.255150@a75g2000cwd.googlegroups.com... > >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. > > > > 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
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, click to view] Mike Brind wrote:
> 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
[quoted text, click to view] "ManningFan" <manningfan@gmail.com> wrote in message news:1169481195.114854.248970@v45g2000cwv.googlegroups.com... > Mike Brind wrote: >> "ManningFan" <manningfan@gmail.com> wrote in message >> news:1169231568.206216.255150@a75g2000cwd.googlegroups.com... >> >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. >> > >> >> 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 >> > 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'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
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> [quoted text, click to view] "ManningFan" <manningfan@gmail.com> wrote in message news:1169485396.398161.134350@51g2000cwl.googlegroups.com... > Can you give me an example of the proper insert statement if I had 3 > checkboxes on a form, chk1, chk2 and chk3? > > Mike Brind wrote: >> 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 >
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 [quoted text, click to view] "ManningFan" <manningfan@gmail.com> wrote in message news:1169485396.398161.134350@51g2000cwl.googlegroups.com... > Can you give me an example of the proper insert statement if I had 3 > checkboxes on a form, chk1, chk2 and chk3? > > Mike Brind wrote: >> 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 >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |