Submitting Page Info to DB!

Results 1 to 2 of 2

Thread: Submitting Page Info to DB!

  1. #1
    Join Date
    Dec 1969

    Default Submitting Page Info to DB!

    This is a general question:<BR><BR>I have now got an ASP page to populate a # of dropdowns and textboxes. Now I want to store the info entered by user to a table in my database (once the user clicks the SUBMIT button). I am assuming that i need to setup a javascript function (clientside) that will do this for me (ie onclick...etc)?? How do I submit the page and hence all the texbox/dropdown information?<BR><BR>P.S. Does my &#039checking&#039 (to ensure the fields are all filled with relevant info) go in the same function?<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Submitting Page Info to DB!

    to insert into the db, have your form "action" point to the form "handler"<BR><BR>in the form handler, open your DB and RS connections and use either SQL or ADO to insert the data:<BR><BR>objRS.AddNew<BR>objRS("firstname") = Request.Form("firstname")<BR>&#039 more fields in here<BR>objRS.Update<BR><BR>do this for all fields you need populated, <BR>then close your DB and RS Connections

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts