05. januar 2002 - 01:11
Der er
5 kommentarer og 1 løsning
Banne ip
Hvad er det galt med dette ? <% ipStr = Request.ServerVariables(\"REMOTE_ADDR\") Set conn = Server.CreateObject(\"ADODB.Connection\") DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.mappath(\"bogen.mdb\") & \"; UID=Administrator; PWD=\" conn.open DSN SQL = \"SELECT ip FROM ip WHERE ip = ´\" & ipStr & \"´\" Set rs = Conn.Execute ( SQL ) if not rs.EOF then response.write \"Du har ikke adgang til denne side!\" end if set rs = nothing set conn = nothing %> /cygnet
Annonceindlæg fra Deloitte
05. januar 2002 - 01:11
#1
denne fejl kommer : Microsoft OLE DB Provider for ODBC Drivers error \'80040e14\' [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression \'ip = ´62.243.113.165´\'. /pokemaster/ban.asp, line 10
06. januar 2002 - 02:58
#5
Du skal bruge \' istedet for ´ <% ipStr = Request.ServerVariables(\"REMOTE_ADDR\") Set conn = Server.CreateObject(\"ADODB.Connection\") DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & server.mappath(\"bogen.mdb\") & \"; UID=Administrator; PWD=\" conn.open DSN SQL = \"SELECT ip FROM ip WHERE ip = \'\" & ipStr & \"\'\" Set rs = Conn.Execute ( SQL ) if not rs.EOF then response.write \"Du har ikke adgang til denne side!\" end if set rs = nothing set conn = nothing %>