Solved

E-newsletter: need to keep track of subscriptions expiring

Posted on 2004-08-23
7
282 Views
Last Modified: 2009-12-16
I am looking to do the following with ASP.

We have a website where a person will be able to subscribe to a paid e-newsletter

These things are in place:

1) Subscribe to an e-newsletter – I have a pre-built solution which  I have not gotten to work yet but I believe it’s just a few mail server settings.
http://www.tassietek.com/mailerfree/default.asp
or
http://www.tassietek.com/mailerpro/

2) pay for newsletter
This is in place – we have an existing internet merchant account which goes to authorize.net and we are already able to make this work with taking secure payments from a web page form with ASP

3) This is where I need the help. How do you keep track of a persons subscription expiring -- 149.00 for 1 year -- and toward the end of the one year, generate an email to the person that the subscription is due for renewal.

The mailer free or mailer pro comes with a decent pre-built Access database.

-- Dan
0
Comment
Question by:danomatic
7 Comments
 
LVL 46

Accepted Solution

by:
fritz_the_blank earned 300 total points
ID: 11872567
So what you need to start with is a SQL select that will give you the records that you need:

strSQL = "SELECT * FROM tblYourTable WHERE DateDiff('d',datYourDateField,Date())<45"

for example would give you all records that will expire in the next 45 days.

FtB
0
 
LVL 3

Assisted Solution

by:JagC
JagC earned 200 total points
ID: 11872944
Does the access database come with an expiry date field in the user table? If not then add one. You may need to modify your subscription pages to add an entry in this field.
Eg if they sign up for a year add the field as:

DateAdd("M",12,now())

This would add 12 months to the current date.

If you want to send out a reminder (assuming it's not included with the news script) you need a function that will mail those that are going to run out soon. Without getting into scheduled scrpipting (covered loads of times on EE) I'd do the check when sending out the newsletter.
If the newsletter script already has an expiry check then great. (If not add it - see above).

When sending out hte newsletter, call a separate function which checks to see which accounts are going to run out (use FtBs sql statement).

Doing it as a function and calling it when the newsletter is sent means that a user will recieve the newsletter and a separate reminder email.

This all assumes though that this email program isn't wrapped up in a DLL or something :)
0
 
LVL 4

Expert Comment

by:MrClean21
ID: 11872959
Hi,

You could use an expireDate field in the database and select * where expireDate > Date().
To email a notification, you could use a vbscript running in a scheduled task every night sending an email to everyone who has select * where expireDate = DateAdd('d', 7, Date())

MrClean
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 3

Author Comment

by:danomatic
ID: 11873701
wow, ok I have to digest some of this.

Let me check on the script to see if there is any means of expring a subscription.  There are no DLL's invloved at all, just ASP and soem VBScript.
0
 
LVL 3

Author Comment

by:danomatic
ID: 12098457
I am sorry, I have gotten held up on this project, I will resume this week.
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12101837
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 12327641
Glad to have helped, but any reason for the grade of B?

FtB
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now