Form fejl når alle felter ikke er udfyldt
Hejsa jeg har et problem med min form. Det er lavet sådan at når folk har ufdfyldt min form kommer det ned i en database. Men hvis ikke at alle felterne er udfyldt kommer den med at \" siden kan ikke vises\" Hvis alt er udfyldt virker det fint.Hvordan laver jeg sådan at selvom ikke alle felter er udfyldte, kommer de felter som er udfyldt ned i databasen.
Min ASP :
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString(\"mode\")
tempConn = \"PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\") & \";UID=admin;PWD=;\"
If Request.Form(\"Gem\") <> \"\" Then
strfirma = Trim(Request.Form(\"firma\"))
strperson = Trim(Request.Form(\"person\"))
stradresse = Trim(Request.Form(\"adresse\"))
strby = Trim(Request.Form(\"by\"))
strpost = Trim(Request.Form(\"post\"))
strtelefon = Trim(Request.Form(\"telefon\"))
strfax = Trim(Request.Form(\"fax\"))
stremail = Trim(Request.Form(\"email\"))
strdomain = Trim(Request.Form(\"domain\"))
strpege = Trim(Request.Form(\"pege\"))
strpassword = Trim(Request.Form(\"password\"))
strKommentar = Trim(Request.Form(\"Kommentar\"))
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
strSQL = \"SELECT * FROM news WHERE (ID = 0)\"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs(\"firma\") = strfirma
rs(\"person\") = strperson
rs(\"adresse\") = stradresse
rs(\"by\") = strby
rs(\"post\") = strpost
rs(\"telefon\") = strtelefon
rs(\"fax\") = strfax
rs(\"email\") = stremail
rs(\"domain\") = strdomain
rs(\"pege\") = strpege
rs(\"password\") = strpassword
rs(\"Kommentar\") = strKommentar
rs(\"Dato\") =Date()
rs(\"chekck\") = request.form(\"checkbox\")
rs.Update
End If
rs.Close
Set rs = Nothing
End If
%>
<html>
<head>
<title>Nyheder</title>
</head>
<body>
<div align=\"center\"><center>
<table width=\"488\" border=\"0\" cellspacing=\"0\" cellpadding=\"3\">
<tr>
<td>
<form method=\"POST\" action=\"indlaeg.asp\">
<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"2\">
<tr>
<td valign=\"middle\" align=\"left\" colspan=\"2\"><font face=\"arial\" size=\"2\"><B><br>
</B>Indtast venligst oplysningerne i følgende felter:<B><br>
</B></font></td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Firma</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"firma\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Person</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"person\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Adresse</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"adresse\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">By / Post nr.</font></B>
</td>
<td valign=\"middle\" align=\"left\"> <font color=\"#FFFFFF\">
<input type=\"text\" name=\"by\" size=\"24\">
,</font>
<input type=\"text\" name=\"post\" size=\"10\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Telefon</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"telefon\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Fax</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"fax\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Email</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"email\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Domain navn</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"domain\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Pege</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"pege\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Password</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"text\" name=\"password\" size=\"40\">
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">test</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<input type=\"checkbox\" name=\"checkbox\" value=\"true\">
</td>
</tr>
<tr>
<td valign=\"top\" align=\"left\"><div align=\"right\">
<p><B><font face=\"arial\" size=\"2\">Kommentar</font></B>
</td>
<td valign=\"middle\" align=\"left\">
<textarea rows=\"3\" name=\"Kommentar\" cols=\"40\"></textarea>
</td>
</tr>
<tr>
<td valign=\"middle\" align=\"left\" colspan=\"2\"><br>
<input type=\"submit\" value=\"Gem\" name=\"Gem\">
<input type=\"button\" value=\"Annuller\" name=\"Annuller\" onClick=\"java script:history.back();\">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<form name=\"form1\" method=\"post\" action=\"\">
</form>
<p> </p>
</center></div>
</body>
</html>
