Fejl Igen :(
Fejl:Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression \'godkendt=\'Ja\' and\'.
/script/asp/jwringetoner/test.asp, line 64
Linje 64:
Set rs = Conn.Execute (str_sql2)
og lige af scripten:
<%
str_alfa = request.querystring(\"alfa\")
bo_start = true
do while len(str_alfa) > 0
if bo_start = true then
str_sql1 = \" left(navn,1) = \'\" & left(str_alfa, 1) & \"\'\"
bo_start = false
else
str_sql1 = str_sql1 & \" or left(navn,1) = \'\" & left(str_alfa, 1) & \"\'\"
end if
str_alfa = right(str_alfa, len(str_alfa) - 1)
loop
Set Conn = Server.CreateObject(\"ADODB.Connection\")
Conn.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.MapPath(\"database.mdb\")
str_sql2 = \"SELECT * FROM jwringetoner WHERE godkendt=\'Ja\' and \" & str_sql1 & \" ORDER BY navn\"
Set rs = Conn.Execute (str_sql2)
%>
