Fejl i query expression
Jeg får denne fejl:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Adresser=test@hotmail.com'.
/unsubscripe.asp, line 14
Hele siden ser således ud:
<%
Dim Connect, connString, conn, rs
Set Connect = Server.CreateObject("ADODB.Connection")
connString = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("emails.mdb")
Connect.Open connString
Set rs = Server.CreateObject("ADODB.Recordset")
emailadresse = request.queryString("emailadresse")
If request.QueryString("stage")="unsubscripe" Then
dim query
Query = "SELECT * FROM Maillist WHERE Adresser=" & emailadresse
rs.Open Query, Connect, 1, 2
rs.Delete
End If
response.write "Du er nu fjernet fra mailinglisten"
Connect.Close
Set Connect = Nothing
%>
I min query vil jeg søge alle poster i tabellen 'Maillist' hvor 'Adresser' matcher strengen der bliver sendt, der hedder 'emailadresse'.
Hvad er der galt?
