Re: I'm phuxored (complete ASP n00b) - Multiple checkboxes on a form?


"ManningFan" <manningfan@xxxxxxxxx> wrote in message
news:1169481195.114854.248970@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Mike Brind wrote:
"ManningFan" <manningfan@xxxxxxxxx> wrote in message
news:1169231568.206216.255150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Im phuxored (complete ASP n00b) - Multiple checkboxes on a form?
    ... keep it so that if more checkboxes are added in the future I can do it ... Mike Brind wrote: ... I understand some of the theory but I know little to nothing about ASP. ... What's the best way to set up a tableso that I can store individual ...
    (microsoft.public.inetserver.asp.db)
  • Re: Im phuxored (complete ASP n00b) - Multiple checkboxes on a form?
    ... Because we gave the same name to each of the checkboxes, this grouped them, ... If you are happy to store "Red,Green" in the field for Q1, then the Insert ... Mike Brind wrote: ... bunch of checkboxes". ...
    (microsoft.public.inetserver.asp.db)
  • MultiDimensional Array
    ... I have the value of checkboxes coming into an asp page. ... and call a stored procedure for populating a table? ... Thanks a bunch. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Help me please before I go insane
    ... The checkboxes are easily handle on the website. ... I assume that on an .asp ... > I have an access database and using Front Page, I created an ASP page> that displays all the results of the whole database. ...
    (microsoft.public.access.queries)
  • Re: How to Insert date in sql server database
    ... I am getting input from the HTML form and store it to database using ... (it's VB6 and not ASP, but I believe that they are not too different): ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
Loading