Fejl i script
Hvorfor er det kun "Søg på alt" der virker i dette script.Fejlmeddelelse er:
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e0c'
Der er ikke defineret nogen kommando svarende til kommandoobjektet.
/aida2/pension/search_diagnoseliste.asp, linje 185
Koden er:
<%
Path = "C:\aida\pension\"
DBName = "diagnoseliste.mdb"
set Conn = server.createobject("ADODB.Connection")
Conn.Open "DBQ=" & Path & DBName & ";DefaultDir=" & Path & ";Driver={Microsoft Access Driver (*.mdb)}"
if Request.Form("valg") = "Søg på alt" then
SQL = "SELECT * FROM [diagnoseliste] WHERE [diagnoseliste].[who] LIKE '%" & Request.Form("search") & "%' OR [diagnoseliste].[diagnose] LIKE '%" & Request.Form("search") & "%' OR [diagnoseliste].[diagnosekode] LIKE '%" & Request.Form("search") & "%' ORDER BY [diagnoseliste].[diagnose]"
end if
if Request.Form("valg") = "Who kode" then
SQL = "SELECT * FROM [diagnoseliste] WHERE [diagnoseliste].[who] LIKE '%" & Request.Form("search") & "%' ORDER BY [diagnoseliste].[diagnose]"
end if
if Request.Form("valg") = "diagnose" then
SQL = "SELECT * FROM [diagnoseliste] WHERE [diagnoseliste].[diagnose] LIKE '%" & Request.Form("search") & "%' ORDER BY [diagnoseliste].[diagnose]"
end if
if Request.Form("valg") = "diagnosekode" then
SQL = "SELECT * FROM [diagnoseliste] WHERE [diagnoseliste].[diagnosekode] LIKE '%" & Request.Form("search") & "%' ORDER BY [diagnoseliste].[diagnose]"
end if
set Result = Conn.Execute(SQL)
if request.form("search") = "" then
Response.Write "<table width=400><tr><td><span class=text>Du har ikke indtastet et søgeord</P><P><A HREF=search_diagnoseliste.htm>Prøv igen</A></SPAN></tr></td></table>"
elseif Result.Eof then
Response.Write "<table width=400><tr><td><span class=text>Din søgning gav desværre intet resultat</P><P><A HREF=search_diagnoseliste.htm>Prøv med en bredere søgning</A></SPAN></tr></td></table>"
else
Response.Write "<table width=400 border=0 cellpadding=4 cellspacing=0><tr><td bgcolor=#C2B26A><span class=text>Din søgning gav følgende resultat (sorteret efter afgørelsesdato):</SPAN></td></tr></table>"
do while not Result.Eof
Response.Write "<table border=""0"" width=""400"" bgcolor=#EFEAD6>"
Response.Write "<tr><td width=""300"">" & "<span class=text><b>WHO kode</b> " & Result("who") & "</SPAN></td></tr>"
Response.Write "<tr><td width=""300"">" & "<span class=text><b>Diagnose</b> " & Result("diagnose") & "</SPAN></td></tr>"
Response.Write "<tr><td width=""300"">" & "<span class=text><b>Diagnosekode</b> " & Result("diagnosekode") & "</SPAN></td></tr>"
Response.Write "</td></tr></table>"
Result.Movenext
i = i + 1
loop
end if
%>
