Söktrubbel... — webForum

BireMedlem sedan dec. 199919 074 inlägg

Frågan21 maj 2000 08:11#1

Jag håller på med en sökbar gigkalender till Enviken Records och får detta felmeddelande:

Microsoft OLE DB Provider for ODBC Drivers fel '80040e14'

[Microsoft][Drivrutin för ODBC Microsoft Access] Syntaxfel (operator saknas) i frågeuttrycket 'Band LIKE '%falun%' OR Ort LIKE '%falun%''.

/Envikenrecords/gig/search.asp, rad 6

Koden ser ut så här:

<%
Set Connection = Server.CreateObject("ADODB.Connection")
Connection.Open Session("ConnGig_ConnectionString")

SQLStmt = "SELECT Gig.* FROM Gig WHERE Band LIKE '%" & Request.Form("keyword") & "%' OR Ort LIKE '%" & Request.form("keyword") & "%' Order by Datum"
Set RS = Connection.Execute(SQLStmt)

SQLStmt = "SELECT Count(*) AS ItemCount FROM Gig WHERE Band LIKE '%" & Request.form("keyword") & "%' OR Ort LIKE '%" & Request.form("keyword") & "%'"
Set RS2 = Connection.Execute(SQLStmt)
%>
<html>
<head>
<title>ENVIKEN RECORDS</title>
<link rel="stylesheet" type="text/css" href="styles/shop.css">
</head>
<body background="images/rightbg.jpg" bgproperties="fixed" bgcolor="#FF9933">
<%
If RS.EOF Then 
Response.Write("<hr Size='1' Color='#8080GG'><font face=Verdana Size='2' Color='#800000'><center><b>Tyvärr, inget matchade din sökning.</b></center></font><br><center><form method='POST' action='search.asp' target='main'><input type='text' name='keyword' size='40' tabindex='1' Value='Ny sökning...'><INPUT TYPE='submit' VALUE='Sök ! '></form></center><hr Size='1' Color='#8080GG'>")
Else
%>
	<table border="0" width="95%" height="100%" align="left">
	<tr>
	<td align="left">
<font face="Verdana" Size="2" Color="#000000"><center>
<a href="enter.asp" target="main" onClick="this.blur();"><img src="images/categories.gif" border="0">
</a>
<br><b>Dessa skivor matchade din sökning:</b> 
<br></font><font face="Verdana" Size="2" Color="#800000">
<b>" <%= Request.form("keyword")%> "</b></font></center>

<% DO UNTIL RS.EOF %>
<div align="center">
	<table border="0" Width="95%">
	<tr>
	<td colspan="4" Width="100%">
<font face="Verdana" Size="2" Color="#800000"><center><b>ROCK & ROLL KALENDERN</b><hr size="1" Color="#48631D"><hr size="1" Color="#48631D"></center></font>
	</td>
	</tr>
	<tr>
	<td colspan="4" Width="100%">
<table border="0" width="95%" cellspacing="0" cellpadding="0">

	<tr>
    	<td width="100"><font face="Verdana" size="1" color="#48631D">
<%= CmdShowEntries("Datum") %></font>
	</td>
   	 <td width="200" align="right"><font face="Verdana" size="1" color="#48631D">
<%= CmdShowEntries("Hak") %></font>
	</td>
    	<td width="150"><font face="Verdana" size="1" color="#48631D">
<%= CmdShowEntries("Ort") %></font>
	</td>
	</tr>
	<tr>
   	 <td width="100%" colspan="3"><font face="Verdana" size="1" color="#800000">Attraktion:</font> <font face="Verdana" size="2" color="#FFFFFF">
<%= CmdShowEntries("Band") %></font>
	</td>
	</tr>	
	<tr>
   	 <td width="100%" colspan="3"><font face="Verdana" size="1" color="#800000">Övrig info:<br></font> <font face="Verdana" size="2" color="#800000">
<%= CmdShowEntries("Info") %></font>
<hr size="1" Color="#48631D">
	</td>
	</tr>
</table>
	</td>
	</tr>
	</table>

</div>

<%
RS.MoveNext
loop
%>
<%end if%>

	</td>
	</tr>
	</table>
</body>
</html>
<%
RS.Close
Connection.Close
%>

Vad är problemet månne ?

------------------
Krister </BIRE> Lindholm
http://www.lifestyleshop.nu
webmaster@livsstilsbutik.com

BireMedlem sedan dec. 199919 074 inlägg

21 maj 2000 09:50#2

Jag fick horn i pannan och löste det... :e

SQLStmt = "SELECT Gig.* FROM Gig WHERE Gig.Band LIKE '%" & Request.Form("keyword") & "%' OR Gig.Ort LIKE '%" & Request.form("keyword") & "%' Order by Datum"
Set RS = Connection.Execute(SQLStmt)

Så ska det se ut om det ska funka märkte jag ! :e *glad*

------------------
Krister </BIRE> Lindholm
http://www.lifestyleshop.nu
webmaster@livsstilsbutik.com