asp fejl
Halløj eksperterHvad går galt? Jeg får følgende asp fejl:
Microsoft OLE DB Provider for ODBC Drivers error ''80040e10''
[Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 2.
/kim/asp/tekst/fravaer.asp, line 36
Kilden er:
<% Response.Buffer = True %>
<html><head>
<title>Søgeresultat</title>
</head><body>
<%
strKeyword = Trim(Request.Form("Keyword"))
If Len(strKeyword) = 0 Then
Response.Clear
Response.Redirect("search.htm")
Else
'' Hvis der er skrevet i feltet
strKeyword = Replace(strKeyword,"''","''''")
End If
strSQL = "SELECT ID, Efternavn, Fornavn, Initialer, Adresse1, Postnr, Telefonnr, Titel, Faggruppe, Grunduddannelse FROM Personale WHERE"
strSQL = strSQL & " (Fornavn LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Initialer LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Adresse1 LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Postnr LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Telefonnr LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Titel LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Faggruppe LIKE ''%" & strKeyword & "%'')"
strSQL = strSQL & " OR (Grunduddannelse LIKE ''%" & strKeyword & "%'')"
'' Skaber DSNLess forbindelse til DBen
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("fravaer.mdb")
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open strDSN
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<p>Søgeresultat</p>"
Response.Write "<table border=1>"
Response.Write "<tr><th>Fornavn</th><th>Initialer</th><th>Adresse1</th><th>Postnr</th><th>Telefonnr</th><th>Titel</th><th>Faggruppe</th><th>Grunduddannelse</th></tr>"
Do While Not rs.EOF
Response.Write "<tr><td>" & rs("Fornavn") & "</td>"
Response.Write "<td>" & rs("Initialer") & "</td>"
Response.Write "<td>" & rs("Adresse1") & "</td>"
Response.Write "<td>" & rs("Postnr") & "</td>"
Response.Write "<td>" & rs("Telefonnr") & "</td>"
Response.Write "<td>" & rs("Titel") & "</td>"
Response.Write "<td>" & rs("Faggruppe") & "</td>"
Response.Write "<td>" & rs("Grunduddannelse") & "</td></tr>"
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p>Der er ikke fundet noget på denne søgning</p>"
End If
myConn.Close
Set myConn = Nothing
%>
</body></html>
