Der mangler en operator i forespørgselsudtrykket
Hvad kan være galt?[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'forenings_id = 2 AND hoved_menu = se 1 - 5 AND side_menu = menu 1'.
og i ultradev siger den:
Der mangler en operator i forespørgselsudtrykket
<%
Dim rs_side__MMColParam
rs_side__MMColParam = "1"
If (Request.Cookies("forenings_id") <> "") Then
rs_side__MMColParam = Request.Cookies("forenings_id")
End If
%>
<%
Dim rs_side__MMhm
rs_side__MMhm = "se 1 - 5"
If (Request.QueryString("hm") <> "") Then
rs_side__MMhm = Request.QueryString("hm")
End If
%>
<%
Dim rs_side__MMsm
rs_side__MMsm = "menu 1"
If (Request.QueryString("sm") <> "") Then
rs_side__MMsm = Request.QueryString("sm")
End If
%>
<%
Dim rs_side
Dim rs_side_numRows
Set rs_side = Server.CreateObject("ADODB.Recordset")
rs_side.ActiveConnection = MM_aarhusejendoms_STRING
rs_side.Source = "SELECT * FROM sider WHERE forenings_id = " + Replace(rs_side__MMColParam, "'", "''") + " AND hoved_menu = " + Replace(rs_side__MMhm, "'", "''") + " AND side_menu = " + Replace(rs_side__MMsm, "'", "''") + ""
rs_side.CursorType = 0
rs_side.CursorLocation = 2
rs_side.LockType = 1
rs_side.Open()
rs_side_numRows = 0
%>
