Newsletter Unsubscribe

[Firstfactor]

Hi, I have set up a newsletter and what to add add a Unsubscribe link. can anybody suggest the best process to ideally automate Unsubscribe. I'm using ASP.

[Stom]

have a form with a single field: email address.

pass this form to an asp script, say unsubscribe.asp

in that file have the code somethign liek thus:

<%
---insert your connect to db code here--

rs.filter = "email = '" & request.form("email") & "'"
if rs.RecordCount > 0 Then
rs.Delete
response.write("successfully unsubscribed")
else
response.write("email address not found")
end if
rs.filter = adFilterNone
%>


does that help?