|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
November 25th, 2003, 05:26 PM
|
|||
|
|||
|
'Remove Me' feature in e-mail blasts
Am looking to setup a link at the bottom of my e-mail brodcasts that let a person remove themselves from my e-mail list. I know who each person is that I send to and we will be embedding their ID number in the 'Unsubscribe' link of the e-mail that goes to them. When they click on that link and get taken to the ASP page, I want to take that ID number provided in the URL, look it up in our database and update and update their preferences column in the database with the appropriate data. I'm new at coding an not quite sure how to go about this. Am told that I should use the request.querystring method to handle. Are there any examples out there that might be geared toward what I'm trying to do?
|
|
#2
November 25th, 2003, 06:37 PM
|
||||
|
||||
|
updateDatabase.asp page
Code:
'Grab the emailId from the querystring
emailId = Request.QueryString("EmailId")
'Set the connection object
Set Conn = Server.CreateObject("ADODB.Connection")
'Open the connection to the database
Conn.Open(connection information)
'Create the update statement that will be executed
updateEmail = "UPDATE table SET preference = 'preference' WHERE EmailId = " & emailId & ""
'Execute the SQL statement
Conn.Execute(updateEmail)
'Close the connection
Conn.Close
'Set the connection object to nothing
Set Conn = nothing
|
|
| Viewing: ASP Free Forums > Other > Programming Help > 'Remove Me' feature in e-mail blasts |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
