Fejl i sql
Hvorfor får jeg syntaksfejl her:Fejl:
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e14'
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i strengen i forespørgselsudtrykket "(diagnoseliste.diagnosekode = 223)" ORDER BY [diagnoseliste].[diagnose]".
/aida2/pension/search_diagnoseliste.asp, linje 185
Linie 185: set Result = Conn.Execute(SQL)
Kode:
<%
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 = " & 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 rowspan=3 width=18 valign=top align=center><img src=../images/link.gif halign=center></td><td width=""300"" valign=top>" & "<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><br><br></td></tr>"
Response.Write "</td></tr></table>"
Result.Movenext
i = i + 1
loop
end if
%>
