kan någon se felet i denna sql sats?
SQL = "SELECT * FROM users WHERE ((Email = " & uid & ") AND (Password = " & pwd & ")) OR " & IP & " LIKE IP + '%'"

Följande felmeddelande

Line 1: Incorrect syntax near ')'.

Anders

SQL = "SELECT * FROM users WHERE ((Email = " & uid & ") AND (Password = '" & pwd & "')) OR " & IP & " LIKE IP + '%'"

prova att lägga in ' ' vid Password.men jag vet ju inte om det bara är siffror eller ej.

Anvnd ett command med parametrar istället:

<%
Dim cmd 'As ADODB.Command
Const adVarChar = 200
Const adParamInput = 1

    Set cmd = CreateObject("ADODB.Command")
    Set cmd.ActiveConnection = Conn 'Ersätt med din anslutning
    cmd.CommandText = "SELECT *" & cvCrLf & _
                      "FROM [users]" & cvCrLf & _
                      "WHERE (([Email] = @Email) AND ([Password] = @Password)) OR (@IP LIKE IP + '%')"
    cmd.Parameters.Append cmd.CreateParameter("@Email", adVarChar, adParamInput, 20, uid)
    cmd.Parameters.Append cmd.CreateParameter("@Password", adVarChar, adParamInput, 20, pwd)
    cmd.Parameters.Append cmd.CreateParameter("@IP", adVarChar, adParamInput, 20, IP)


    Set rs = CreateObject("ADODB.Recordset")
    rs.Open cmd

    If rs.Eof Then

    Else

    End If

%>