Peter J. Boettcher — Sat, 04 Mar 2000 20:18:00 +0000

Ravi,

This is a relatively simple thing to do. Just make a simple html form being sure to name all the input fields accordingly. Then make a handler page using an ASP file that will serve as the form action:

Name = Request.Form("Name")
Age = Request.Form("Age") etc..

Once you've validated all your input and are ready to insert it into the table then you would do something like this (using ADO):

'---Make your ADO connection
Set Conn = Server.CreateObject("ADODB.Connection")

'---Create the record
Set RSSignup = Server.CreateObject("ADODB.Recordset")

'---Pass your authentication
Conn.Open "DSN=YourDB DSN;UID=YourID;PWD=YourPassword"

'---Set connection type, open and add new record
RSSignup.ActiveConnection = Conn
RSSignup.CursorType = 3
RSSignup.LockType = 2
RSSignup.Source = "YourTableName"
RSSignup.Open
RSSignup.AddNew

'---All fields you're saving go here
RSSignup("Name") = Name
RSSignup("Age") = Age

'---Final Update of record, move cursor back to beginning of database and close
RSSignup.Update
RSSignup.MoveFirst
RSSignup.Close

'---Set connections to nothing to free memory
Set RSSignup = nothing
Conn.Close
Set Conn = nothing

You'll have to make sure that all fields that you're going to save to your database have been validated before you save them. You'll also have to create the corresponding table that is going to hold all these values in your database.

I hope that's not to confusing

Regards,
Peter J. Boettcher