Hvorfor får jeg typeuoverensstemmelse?
Hvorfor får jeg typeuoverensstemmelse?Koden er som følger:
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("news2.mdb") & ";UID=admin;PWD=;"
If Request.Form("Gem") <> "" Then
strTruffet = Trim(Request.Form("Truffet af"))
strJournal = Trim(Request.Form("Journal"))
strAfgoerelsesdato = Trim(Request.Form("Afgoerelsesdato"))
strUdsendelsesdato = Trim(Request.Form("Udsendelsesdato"))
strMeddelelse = Trim(Request.Form("Meddelelse"))
strOm = Trim(Request.Form("Om"))
strLov = Trim(Request.Form("Lov"))
strBekendtgoerelse = Trim(Request.Form("Bekendtgoerelse"))
strResume = Trim(Request.Form("Resume"))
strSagsfremstilling = Trim(Request.Form("Sagsfremstilling"))
strAfgoerelse = Trim(Request.Form("Afgoerelse"))
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM sm WHERE (ID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("Truffet af") = strTruffet
rs("Journal") = strJournal
rs("Afgoerelsesdato") = strAfgoerelsesdato
rs("Udsendelsesdato") = strUdsendelsesdato
rs("Meddelelse") = strMeddelelse
rs("Om") = strOm
rs("Lov") = strLov
rs("Bekendtgoerelse") = strBekendtgoerelse
rs("Resume") = strResume
rs("Sagsfremstilling") = strSagsfremstilling
rs("Afgoerelse") = strAfgoerelse
rs.Update
End If
rs.Close
Set rs = Nothing
End If
%><html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF">
<table width="400" border="0" cellpadding="5">
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2">Indtastning af SM</font></td>
</tr>
<tr valign="top">
<td>
<form method="post" action="sm_indtastning.asp">
<table width="380" border="0">
<tr>
<td> <font face="Arial, Helvetica, sans-serif" size="2">Afgørelse
truffet af:
<input type="text" name="Truffet af">
</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2"> Journal nr.
<input type="text" name="journal">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2"> Afgørelsesdato
<input type="text" name="Afgoerelsesdato">
</font></td>
<td><font face="Arial, Helvetica, sans-serif" size="2"> SM Udsendelsesdato
<input type="text" name="Udsendelsesdato">
</font></td>
</tr>
<tr>
<td><font face="Arial, Helvetica, sans-serif" size="2"> Meddelelse
om
<input type="text" name="Meddelelse">
</font></td>
<td><font size="2"></font></td>
</tr>
</table>
<p> <font face="Arial, Helvetica, sans-serif" size="2">Lov<br>
<textarea name="lov" cols="60" rows="4"></textarea>
</font></p>
<p><font face="Arial, Helvetica, sans-serif" size="2"> Bekendtgørelse<br>
<textarea name="Bekendtgoerelse" cols="60" rows="4"></textarea>
</font></p>
<p> <font face="Arial, Helvetica, sans-serif" size="2">Resume<br>
<textarea name="Resume" cols="60" rows="4"></textarea>
</font></p>
<p> <font face="Arial, Helvetica, sans-serif" size="2">Sagsfremstilling<br>
<textarea name="Sagsfremstilling" cols="60" rows="8"></textarea>
</font></p>
<p> <font face="Arial, Helvetica, sans-serif" size="2">Afgørelse<br>
<textarea name="Afgoerelse" cols="70" rows="12"></textarea>
</font></p>
<p><input type="submit" value="Gem" name="Gem"></p>
</form>
</td>
</tr>
</table>
<p> </p>
<p> </p>
</body>
</html>
