INSERT NEW RECORD

There are a lot of instances where you may need to add new records to your database. For example, it is always a good idea to have your website contact form be recorded in your database for future reference.

To do this, you first need to create a database called MyData. Then create a table called tblContact with these fields:
ID - autonumber
Email - text field
FirstName - text field
LastName - text field
Comments - memo field
DateContacted - date/time field

Next, create a form page called form.asp and copy the below code into your page:

Email:
First Name:
Last Name:
Comments:

Then, create a page called confirm.asp and copy the below code into your page:



<%
DIM objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open "tblContact", objConn, , adLockOptimistic, adCmdTable

objRS.AddNew
objRS("Email") = Request.Form("Email")
objRS("FirstName") = Request.Form("FirstName")
objRS("LastName") = Request.Form("LastName")
objRS("Comments") = Request.Form("Comments")
objRS("DateContacted") = Date()
objRS.Update
%>

<%
DIM strFirstName
strFirstName = Request.Form("FirstName")
%>,

<%
objRS.Close
Set objRS = Nothing
objCONN.Close
Set objCONN = Nothing
%>

That's all there is to it. Now you can add records to your database.

http://www.aspwebpro.com/aspscripts/records/insertnew.asp