Eks, forudsætter alle dine kolonner i databasen er defineret som text:
<%
if Request.ServerVariables("REQUEST_METHOD") = "POST" then
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="& server.mappath("db101.mdb")
navn = Replace(Request.Form("navn"),"'","''")
adresse = Replace(Request.Form("adresse"),"'","''")
postnr = Replace(Request.Form("postnr"),"'","''")
by = Replace(Request.Form("by"),"'","''")
email = Replace(Request.Form("email"),"'","''")
telefon = Replace(Request.Form("telefon"),"'","''")
svar = Replace(Request.Form("svar"),"'","''")
SQL = "INSERT INTO tabelnavn (navn, adresse, postnr, [by], email, telefon, svar)
SQL = SQL & " VALUES ("
SQL = SQL & "'" & navn & "', "
SQL = SQL & "'" & adresse & "', "
SQL = SQL & "'" & postnr & "', "
SQL = SQL & "'" & by & "', "
SQL = SQL & "'" & email & "', "
SQL = SQL & "'" & telefon & "', "
SQL = SQL & "'" & svar & "', "
Conn.Execute(SQL)
Response.Write("Tak for dit svar.")
else
%>
<html>
<head>
<script language="JavaScript">
function validForm(theform) {
if (theform.navn.value=="") {
alert("Du mangler at udfylde navn");
theform.navn.focus();
return false;
}
if (theform.adresse.value=="") {
alert("Du mangler at udfylde adresse");
theform.adresse.focus();
return false;
}
if (theform.postnr.value=="") {
alert("Du mangler at udfylde post nr.");
theform.postnr.focus();
return false;
}
if (theform.by.value=="") {
alert("Du mangler at udfylde by");
theform.by.focus();
return false;
}
if (theform.telefon.value=="") {
alert("Du mangler at udfylde telefon nummer");
theform.telefon.focus();
return false;
}
if (theform.svar.value=="") {
alert("Du mangler at skrive et svar");
theform.svar.focus();
return false;
}
return true;
}
</script>
</head>
<body>
<center>
<table>
<form action="" method="post" onSubmit="return validForm(this);">
<tr><td>Navn *</td><td><input type="text" name="navn"></td></tr>
<tr><td>Adresse *</td><td><input type="text" name="adresse"></td></tr>
<tr><td>Post nr. *</td><td><input type="text" name="postnr"></td></tr>
<tr><td>By *</td><td><input type="text" name="by"></td></tr>
<tr><td>E-mail</td><td><input type="text" name="email"></td></tr>
<tr><td>Telefon *</td><td><input type="text" name="telefon"></td></tr>
<tr><td>Svar *</td><td><input type="text" name="svar"></td></tr>
<tr><td colspan="2"><input type="submit" name="Send" value="Send"></td></tr>
</form>
</table>
</center>
</body>
</html>
<% end if %>
