Hvad er der galt
Jeg prøver og lave en søgning og kan ikke få det til at virke.Jeg får denne fejlmeddelelse:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression '((Sagsnr LIKE '%er%') OR (Kunde LIKE '%er%') OR (Overskrift LIKE '%er%') OR (beskrivelse LIKE '%er%') OR (brodtekst LIKE '%er%')) And (alle=on))'.
/sog/sog.asp, line 91
her er koden:
<%
strKeyword = Trim(Request.Form("Keyword"))
strType = Request.Form("test")
If Len(strKeyword) = 0 and strType = "alle" Then
strSQL = "SELECT * FROM Query3"
Else if Len(strKeyword) = 0 and strType <> "alle" then
strSQL = "SELECT * FROM Query3 where"
strSQL = strSQL & " "&" " & strType & "=on"
Else if Len(strKeyword) <> 0 and strType = "alle" then
strSQL = "SELECT * FROM Query3 where"
strKeyword = Replace(strKeyword,"'","''")
strSQL = strSQL & " "&" ((Sagsnr LIKE '%" & strKeyword & "%')"
strSQL = strSQL & " OR (Kunde LIKE '%" & strKeyword & "%')"
strSQL = strSQL & " OR (Overskrift LIKE '%" & strKeyword & "%')"
strSQL = strSQL & " OR (beskrivelse LIKE '%" & strKeyword & "%')"
strSQL = strSQL & " OR (brodtekst LIKE '%" & strKeyword & "%'))"
strSQL = strSQL & " And ("&strType&"=on))"
strSQL = strSQL & " Order by ID desc"
End If
end if
end if
Set DBCon = Server.CreateObject("ADODB.Connection")
Set DBCom = Server.CreateObject("ADODB.Command")
Set DBrs = Server.CreateObject("ADODB.RecordSet")
Set rs = Server.CreateObject("ADODB.RecordSet")
Response.Write strSQL
Her står DBCon.ConnectionString
Men er ikke listet (en kunde)
DBCon.Open
DBCom.ActiveConnection = DBCon
DBCom.CommandText= strSQL
'Response.write DBCom.CommandText
rs.Open DBCom,,1,3
