underlig fejle ?
det er engtlig ret enkelt jeg sender et link som dette opretsleeves.asp?linkid=6 til denne form:<%
response.buffer = true
set connect = server.createobject(\"ADODB.Connection\")
Connect.open \"Driver={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.mappath(\"sleevs.mdb\")
strSQL = \"SELECT * FROM kategorier WHERE katid LIKE \'\" & request(\"linkid\") & \"\'\"
set rs = Connect.Execute(strSQL)
%>
<html>
<head>
<title>Opret sleeves</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
<link rel=\"stylesheet\" href=\"tekst.css\" type=\"text/css\">
</head>
<body bgcolor=\"#000000\" text=\"#FFFFFF\" link=\"#FFCC00\" vlink=\"#FFCC00\" alink=\"#FFCC00\">
<p class=\"storskrift\"> </p>
<table border=\"0\" align=\"center\" width=\"700\">
<tr valign=\"middle\" align=\"center\">
<td class=\"links\">Opret sleeves</td>
</tr>
<tr valign=\"middle\" align=\"center\">
<td class=\"links\"> </td>
</tr>
<tr valign=\"middle\" align=\"center\">
<td>
<table width=\"700\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td width=\"10\"> </td>
<td bgcolor=\"#666666\" class=\"linksIndhold\"> </td>
<td width=\"10\"> </td>
</tr>
<tr>
<td width=\"10\"> </td>
<td bgcolor=\"#FFFFFF\">
<form name=\"opretsleeves\" method=\"post\" action=\"opretsleeves.asp?opret=sleeves\">
<table width=\"650\" border=\"1\" align=\"center\" class=\"almskriftblack\">
<tr>
<td colspan=\"2\"> </td>
</tr>
<tr>
<td>Overskrift:</td>
<td>
<input type=\"text\" name=\"overskrift\">
</td>
</tr>
<tr>
<td class=\"almskriftblack\">Notat:</td>
<td>
<textarea name=\"notat\"></textarea>
</td>
</tr>
<tr>
<td>Oprettet dato:</td>
<td><%=FormatDateTime(Date, 2)%></td>
</tr>
<tr>
<td>Oprettet af:</td>
<td>
<input type=\"text\" name=\"oprettetaf\">
</td>
</tr>
<tr>
<td>
<input type=\"hidden\" name=\"kategori\" value=\"<%=rs(\"katid\")%>\">
<input type=\"hidden\" name=\"dato\" value=\"<%=FormatDateTime(Date, 2)%>\">
</td>
<td>
<input type=\"submit\" name=\"Submit\" value=\"Opret sleeves\">
</td>
</tr>
<tr>
<td colspan=\"2\"> </td>
</tr>
<tr>
<td colspan=\"2\"> </td>
</tr>
</table>
</form>
</td>
<td width=\"10\"> </td>
</tr>
<tr>
<td width=\"10\"> </td>
<td bgcolor=\"#666666\" align=\"center\" valign=\"middle\" class=\"almskrift\">Reprocentret
© </td>
<td width=\"10\"> </td>
</tr>
</table>
</td>
</tr>
</table>
<%
select case request(\"opret\")
\'Opret sleeves
case \"sleeves\"
connect.execute(\"INSERT INTO sleevs (overskrift,notat,oprettetaf,kategori,dato) VALUES(\'\" & request.form(\"overskrift\") & \"\',\'\" & request.form(\"notat\") & \"\',\'\" & request.form(\"oprettetaf\") & \"\',\'\" & request.form(\"kategori\") & \"\',\'\" & request.form(\"dato\") & \"\')\")
response.redirect \"sleevs.asp?mode=bestilt\"
end select
%>
</body>
</html>
Når jeg så trykker på opret sleeves så får jeg denne fejl:
ADODB.Field error \'80020009\'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/jimmyrogers/opretsleeves.asp, line 0
Hvad er det der går galt ???
