| Author |
 Topic Search  Topic Options
|
dpyers 
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 27 July 2006 at 11:49pm |
|
lol.
If your win boxes are booted once a day, you can also put something in the application_onstart event in global.asa. You would have to check if it had already run for the day as apps/iis can be restarted several times a day.
|
Lead me not into temptation... I know the short cut, follow me.
|
 |
Demon
Mod Builder Group
Mod-n-Skin Moderator
Joined: 26 July 2003
Status: Offline
Points: 299
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 12:15am |
 dfrancis wrote:
I would imagine that everyone checks their forums every day... well except for dp (grin). Any traffic can trigger the routine. I like the idea so much I'm thinking of writing it myself.
 Be afraid... be very afraid. LOL  |
lol, nice to know. XD
|
|
So Sayith the Demon.
|
|
dfrancis
Senior Member
Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 12:08pm |
dpyers wrote:
lol.
If your win boxes are booted once a day, you can also put something in the application_onstart event in global.asa. You would have to check if it had already run for the day as apps/iis can be restarted several times a day.
|
Yes, I was trying to avoid the need for another table but the best way (I think) is to annotate the email had been sent. My other concern is those people who may not want to receive the auto birthday "spam." Perhaps a new table is the only way to annotate a preference too.
I really liked your idea about SQL server scheduled task. Have you done anything like that before?
|
|
dfrancis
Senior Member
Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 2:22pm |
|
I think I've come up with an idea that will prevent the need for a new table. I'm working on it now and will submit it for critical review shortly.
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 4:39pm |
dpyers wrote:
If it's set up for it, you can also use ms sql mail to send something direcly from the db server.
|
You can use MS SQL Agent on the db server to schedule and run a stored proc and use MS SQL Mail to send the results.
|
Lead me not into temptation... I know the short cut, follow me.
|
|
dfrancis
Senior Member
Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 7:12pm |
broken script removed by self
Edited by dfrancis - 28 July 2006 at 9:44pm
|
|
dfrancis
Senior Member
Joined: 16 March 2005
Location: United States
Status: Offline
Points: 442
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 7:12pm |
dpyers wrote:
dpyers wrote:
If it's set up for it, you can also use ms sql mail to send something direcly from the db server.
|
You can use MS SQL Agent on the db server to schedule and run a stored proc and use MS SQL Mail to send the results.
|
I may use that someday... thanks for the brilliance.
|
|
ToJaRo
Groupie
Joined: 20 April 2005
Location: United States
Status: Offline
Points: 158
|
Post Options
Thanks(0)
Quote Reply
Posted: 28 July 2006 at 8:01pm |
dfrancis wrote:
What you have to do is insert a file include BELOW the configuration data setup. I put it right below the windows authentication call.
'******************************************
'*** Windows Authentication Login ****
'******************************************
If blnWindowsAuthentication Then Call windowsAuthentication()
'******************************************
'*** Birthday addon ****
'******************************************
%><!--#include virtual="/bdayemail.asp"--><%
'******************************************
'*** Setup Last Visit Data ****
'******************************************
'Read in the last visit date
|
Ok... understood everything except in what file to place the above code and what is used to call it and how frequently is it called... daily, hourly, etc.
Thanks a million for the assistance.  I will test as soon as I know the answers.
|
|
|
|
