---
title: "Nybörjarfel?"
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/13736-nybörjarfel"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Dpo"
published: "2002-01-12T23:02:00.000Z"
updated: "2002-01-12T23:04:00.000Z"
replies: 1
views: 153
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/13736-nybörjarfel"
---

# Nybörjarfel?

## #1 — Dpo, 2002-01-12T23:02Z

Hej!
Varför fungerar inte denna kod?
Har försökt allt utan resultat, det står bara

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
\[Microsoft\]\[ODBC Microsoft Access Driver\] Syntax error (missing operator) in query expression 'UserName ='.
/eget/felpass.asp, line 25

kod
\--
\<%@Language=VBScript%\>
\<%Response.Buffer = True%\>
\<%
'BÖRJAN DATABASKOD
Set MyConn=Server.CreateObject("ADODB.Connection")
MyConn.Open "Driver={Microsoft Access Driver (\*.mdb)}; DBQ=" & 

Server.Mappath("Login.mdb")

'cleanup routines

Sub CleanUp(RS)
  RS.Close
  MyConn.Close
  Set RS = Nothing
  Set MyConn = Nothing
End Sub

Sub CleanUp2()
  MyConn.Close
  Set MyConn = Nothing
End Sub
' SLUT DATABAS KOD

woo = "Select banip FROM Login WHERE UserName = " & request.form("UserName") 

Set RS = Myconn.Execute(woo) 

If RS.Eof Then
Response.Write "positive"
else
Response.Write "negative"
End If
%\>

Permalänk: https://www.webforum.nu/p/13736

## #2 — Pace, 2002-01-12T23:04Z

woo = "Select banip FROM Login WHERE UserName = '" & request.form("UserName") & "'"

' runt värden som är text!

Permalänk: https://www.webforum.nu/p/303754

---

Tråden på webben: https://www.webforum.nu/amne/asp/13736-nybörjarfel