I'm writing a very small form application below. If you examine the below code, you will understand form processing.
<%
' Page name MUST BE the same as in the form action below
'declaring variables
Dim objConn, SQL
Dim strFirstName, strLastName, strEmail
Dim strMessage
'checking if form is submitted
'I always use a hidden form field (which is 'wf' here) to check the form submission
If Request.Form("wf") <> "" Then
strFirstName = Request.Form("frmFirstName")
strLastName = Request.Form("frmLastName")
strEmail = Request.Form("frmEmail")
'if every required fields are submitted then start form proccessing
'you may also check every field seperatelly to write a message about them
If strFirstName <> "" And strLastName <> "" And strEmail <> "" Then
'openning the connection
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("database_name.mdb")
'defining the SQL Query that will be executed
'replace the words in brackets with your database fields
SQL = "INSERT INTO [TABLE_NAME] " &_
"([FIRSTNAME], [LASTNAME], [EMAIL])" &_
"VALUES (" &_
"'" & strFirstName & "', " &_
"'" & strLastName & "', " &_
"'" & strEmail & "'" &_
")"
On Error Resume Next
objConn.Execute(SQL)
Response.Write SQL
If err.Description <> "" Then
strMessage = "An error occured, please try later."
Else
strMessage = "You have successfully submitted the below form."
End If
'if not every required field is filled
Else
strMessage = "Please fill every field in the form"
End If
End If
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Untitled</title>
<script>
function CheckForValues(){
// function that will check the form fields
var strFirstName = document.frmRegister.frmFirstName;
var strLastName = document.frmRegister.frmLastName;
var strEmail = document.frmRegister.frmEmail;
if (strFirstName.value == '')
{alert('Please enter your First Name');strFirstName.focus();return false;}
if (strLastName.value == '')
{alert('Please enter your Last Name');strLastName.focus();return false;}
if (strEmail.value == '')
{alert('Please enter your Email');strEmail.focus();return false;}
document.frmRegister.submit();
}
</script>
</head>
<body>
<form action="form.asp" name="frmRegister" method="post" onSubmit="return false;">
<table>
<% If blnError Then %>
<tr>
<td colspan="2">ERROR_NOTE</td>
</tr>
<% End If %>
<tr>
<td>FirstName</td>
<td><input type="text" name="frmFirstName" value="<% =strFirstName %>"></td>
</tr>
<tr>
<td>LastName</td>
<td><input type="text" name="frmLastName" value="<% =strLastName %>"></td>
</tr>
<tr>
<td>Email</td>
<td><input type="text" name="frmEmail" value="<% =strEmail %>"></td>
</tr>
<tr>
<td colspan="2"><input type="submit" value="Submit" onClick="CheckForValues();"></td>
</tr>
</table>
<input type="hidden" name="wf" value="1">
</form>
</body>
</html>
This is, of course, a very simple form proccessing application. You may develop a better form proccessing, like checking if the email is valid, or the First Name field is string only etc.