SELECT

set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation = 3 ' adUseClient
rs.CursorType = 3 ' adOpenStatic
rs.Open "SELECT * FROM tilbudVare where uge =< "&Cint(uge)&" AND uge1 => "&Cint(uge)&" AND priotet='A';", Connect, , , &H0001 ' adCmdText

Cint(uge) er en variabel der ser hvad uge vi er i altså 14

Når jeg kører dette får jeg fejlen:


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

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'uge =< 11 AND uge1 => 11 AND priotet='A''.

tilbud.asp, line 54


Linie 54
rs.Open "SELECT * FROM tilbudVare where uge =< "&Cint(uge)&" AND uge1 => "&Cint(uge)&" AND priotet='A';", Connect, , , &H0001 ' adCmdText