|
| |
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
 |
Trigger script using email? - 4/10/2001 23:21:00
I am trying to make an ASP/Access Newsletter Mailing List (based loosely on a sample script I d/l from a tutorial). So far I can get the names to the database with a form and then send a confirmation notice back to the entered amail address. Is it possible to trigger code with a reply from the email? In my database I have a Yes/No field that is set to no by default and I am looking for a way to set it to yes once the email address has been confirmed. Any ideas? ------------------
The Ultimate List for PC Support.
|
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Trigger script using email? - 4/10/2001 17:15:00
It sounds like you are attempting a similar thing I do in my login.A user receives an email with a link on it.
Clicking on the link goes to an asp page which looks up the user and activates the account. You can pass either a unique ID or a random number and Username so the user is identified acurately. process.asp?ID=1234 When the user (1234) goes to this link, set the field in the database to "true" by updating the user record ------------------
Spooky
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
| |
|
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
|
RE: Trigger script using email? - 4/10/2001 18:59:00
So I could send a link back to the user with the URL to the script and their email address attached. (I think) This will give the script a querystring which it can check against the database and mark the Yes/No field to yes. Right?------------------
The Ultimate List for PC Support.
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Trigger script using email? - 4/10/2001 20:53:00
Basically , yes.
The email doesnt need to be attached.User gets email.
Clicks on link.
link : process.asp?ID=Username Process.asp : Select * from table where ID = 'Username' If valid record, update yes/no field
| |
|
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
|
RE: Trigger script using email? - 4/11/2001 20:01:00
Ok, I am a little confused here. In my case I am not colecting a username, just the email address but I get the point.In a form I would create the query string with something like this FORM ACTION="process.asp" METHOD="post" but I can not figure out how to do it with a link. Do I do it in the mailer body line? Mailer.Body = "Click this link to subscribe " ------------------
The Ultimate List for PC Support.
| |
|
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
|
RE: Trigger script using email? - 4/11/2001 20:39:00
I think I have it or am close to it. It should look something like this:"Click <a href='http://www.mydomain/scripts/process.asp?VID=" + Cstr(objRS("AD")) + "'>this link</a> to subscribe. I will let you know when I get it working.
| |
|
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
|
RE: Trigger script using email? - 4/11/2001 23:30:00
Ok, I give up. The link quesrystring above was taken from another script. I can't get it to work with my script. The VID is a variable from the other script and I don't think it is needed here.The link to the script looks like this: http://www.mydomain/scripts/process.asp and the variable holding the email address is objRS("AD") or should I use the Request.Form("T1") for this. I think they should give the same result because of this line: objRs("AD") = Request.Form("T1") ------------------
The Ultimate List for PC Support. [This message has been edited by Talismanic (edited 04-11-2001).]
| |
|
|
|
Spooky
Posts: 26606
Joined: 11/11/1998
From: Middle Earth
Status: offline
|
RE: Trigger script using email? - 4/11/2001 19:10:00
Something like that :"Click <a href='http://www.mydomain/scripts/process.asp?VID=" & Request.Form("T1") &"'>this link</a> to subscribe" Should work, but it does assume VID is the update key.
| |
|
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
|
RE: Trigger script using email? - 4/12/2001 23:56:00
I have said it before and I am going to say it again, Spooky you are a genious! The link is making the query string so I should be able to get it with a Request.Form, shouldn't I? At this point I am trying to display the email address in the process form with this: <%
Dim GetVid
GetVid = Request.Form("VID")
Response.Write GetVid
%> All I am getting is blank page, what am I doing wrong. ------------------
The Ultimate List for PC Support. [This message has been edited by Talismanic (edited 04-12-2001).]
| |
|
|
|
Mojo
Posts: 2441
From: Chicago
Status: offline
|
RE: Trigger script using email? - 4/12/2001 14:15:00
Try:Request.QueryString("VID")
| |
|
|
|
Talismanic
Posts: 59
From: Three Rivers, MI
Status: offline
|
RE: Trigger script using email? - 4/12/2001 16:15:00
Thanks, jbennett. That worked so I think I am back on track now.------------------
The Ultimate List for PC Support.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
