Try this. All of this code is in one page. The form posts the fields to the same page, updates the database and then allows you to add another record.
When you first come into the page there will be no value in the form field "CMD" so the processing is skipped
<%
'first check to see if there is a new record to add
If request.form("cmd")="Add" then'create database connection
set rs=Server.CreateObject("ADODB.Recordset")
'open the database recordset
rs.open "[your table]", "[your database connection string]", 3, 2, 2
'create new record
rs.addnew
'set the values of the database fields from the submitted form
rs("[yourField_1]")=request.form("[yourFormField_1]")
rs("[yourField_n]")=request.form("[yourFormField_n]")
'etc...
'commit the record to the database
rs.Update
'close the recordset
rs.close
'destroy the database recordset object to conserve server resources
set rs=Nothing
End if
%>
<HTML>
<HEAD>
<!-- your head code goes here -->
</head>
<BODY>
<FORM method=post action="[thisPageName].asp">
<INPUT TYPE="HIDDEN" NAME="CMD" VALUE="ADD">
<INPUT type = text name="[yourFormField_1]">
<!--etc-->
</FORM>
</BODY>
</HTML>
If you omit the line
rs.Addnew
the current record (by default the first record in the recordset) will be updated.
__________________
Remote Control Cars at RC-Playtime.co.uk
adding records in database using vbscript in asp page
Reply With Quote
