Du har inte exekverat SQL-frågan.
Frågan#1
felmed:
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/search.asp, line 34
kod
<html>
<!-- #include file = "adovbs.inc" -->
<head>
<meta http-equiv="Content-Language" content="sv">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>test av funktioner</title>
<link rel="stylesheet" type="text/css" href="text.css">
</head>
<body>
<!-- #include file="sidhuvud.inc" -->
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber1" cellpadding="2">
<tr>
<td width="100%">
<h3>test av funktioner:</h3>
<h3> </h3>
<h3>sök:</h3>
<form method="post" action="search.asp">
<input type="text" name="search" size="20">
<input type="submit" Value="sök">
</form>
<%
if request.form <> "" then
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" &Server.MapPath("addemalmbergadmin/tubsockan.mdb")
Set RecSet = Server.CreateObject("ADODB.Recordset")
SQL = "select * from sockrates where rubrik like '%" & request.form("search") & "%'"
do until recset.EOF
%>
<%=recset("ID")%> <%=recset("Rubrik")%><br>
<%
recset.Movenext
Loop
recset.Close
end if
%>
</tr>
<tr>
<td width="100%"> </td>
</tr>
</table>
</body>
</html>
vad är felet?