Re: delayed email response
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61945
interpreted = N
texte = There ya go Paul. Thanks Charles... Marc Charles Kline wrote: > Paul, > > This solution would be pretty straight forward. > > On the page where you generate the email, instead of using [sendmail] > write the data to a database. > > ID
TIMESTAMPSENT_STATUSSEND_TOSUBJECTMSG_BODY > > You can use this to set your time stamp if you like: > > [text]timestamp=[math]((([math]{[date format=%m/%d/%Y]}[/math])-1) > *86400)+([math]{[time]}[/math])[/math][/text] > > Then you would just query the db using a trigger and use [sendmail] at > that point to send your email. > > So to find a message that is say 5 hours old or older and has not been > sent you could do something like: > > [text]time_five_hours_ago=[math]((([math]{[date format=%m/%d/%Y]}[/ > math])-1)*86400)+([math]{[time]}[/math])-18000[/math][/text] > > [search db=emails_to_send.db&leTIMESTAMPdatarq=[time_five_hours_ago] > &eqSENT_STATUSdatarq=F] > > Not tested, but you get the idea... > > Then, you do your founditems loop and send the emails. For each record > you find you replacefounditems and set the SENT_STATUS=T > > All done. > > - Charles > > On May 6, 2005, at 9:34 AM, paul wrote: > >> Hi Marc >> >> Sounds ideal, I would love to see the code for this, a few hours is >> not a >> problem, I have spent ages trying to work this out >> >> Thanks again >> Paul >> >> >> ----- Original Message ----- >> From: "Marc Thompson" >> To: "WebDNA Talk" >> Sent: Friday, May 06, 2005 2:57 PM >> Subject: Re: delayed email response >> >> >> >>> I've done this several different ways. The best solution for me was to >>> simply include a TimeStamp field with each record. Then create a >>> trigger that runs hourly. The TimeStamp can then be compared, within >>> the code of the trigger, to the current time and action taken based on >>> the results of the comparison. >>> I have code at work I can share if you wish, but that won't be for >>> another couple of hours. Still in my bath robe... >>> >>> Marc >>> >>> -- >>> ------------------------------------------------------ >>> Marc Thompson >>> Software Engineer >>> Office of Information Technology >>> University of Utah >>> marc.thompson@utah.edu >>> work 801.585.9264 >>> ------------------------------------------------------ >>> >>>>>> paul@ast.jagrove.com 05/06/05 5:56 AM >>> >>>>>> >>> Hi >>> >>> I need to send out an email from the storebuilder several hours after >>> the >>> confirmation email, is thsi possible >>> >>> When someone orders at the moment the confirmation goes out >>> immediately, >>> I >>> would like to send a second email some time later, how would I do this? >>> >>> Any help appreciated >>> >>> Thanks >>> Paul >>> >>> BTW if anyone has a Windfows license for sale contact me off list >>> please >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >> >> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > -- > RightCode, Inc. > 900 Briggs Road #130 > Mount Laurel, NJ 08054 > P: 856.608.7908 > F: 856.439.0154 > E: ckline@rightcode.net > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
There ya go Paul. Thanks Charles... Marc Charles Kline wrote: > Paul, > > This solution would be pretty straight forward. > > On the page where you generate the email, instead of using [sendmail] > write the data to a database. > > IDTIMESTAMPSENT_STATUSSEND_TOSUBJECTMSG_BODY > > You can use this to set your time stamp if you like: > > [text]timestamp=[math]((([math]{[date format=%m/%d/%Y]}[/math])-1) > *86400)+([math]{[time]}[/math])[/math][/text] > > Then you would just query the db using a trigger and use [sendmail] at > that point to send your email. > > So to find a message that is say 5 hours old or older and has not been > sent you could do something like: > > [text]time_five_hours_ago=[math]((([math]{[date format=%m/%d/%Y]}[/ > math])-1)*86400)+([math]{[time]}[/math])-18000[/math][/text] > > [search db=emails_to_send.db&leTIMESTAMPdatarq=[time_five_hours_ago] > &eqSENT_STATUSdatarq=F] > > Not tested, but you get the idea... > > Then, you do your founditems loop and send the emails. For each record > you find you replacefounditems and set the SENT_STATUS=T > > All done. > > - Charles > > On May 6, 2005, at 9:34 AM, paul wrote: > >> Hi Marc >> >> Sounds ideal, I would love to see the code for this, a few hours is >> not a >> problem, I have spent ages trying to work this out >> >> Thanks again >> Paul >> >> >> ----- Original Message ----- >> From: "Marc Thompson" >> To: "WebDNA Talk" >> Sent: Friday, May 06, 2005 2:57 PM >> Subject: Re: delayed email response >> >> >> >>> I've done this several different ways. The best solution for me was to >>> simply include a TimeStamp field with each record. Then create a >>> trigger that runs hourly. The TimeStamp can then be compared, within >>> the code of the trigger, to the current time and action taken based on >>> the results of the comparison. >>> I have code at work I can share if you wish, but that won't be for >>> another couple of hours. Still in my bath robe... >>> >>> Marc >>> >>> -- >>> ------------------------------------------------------ >>> Marc Thompson >>> Software Engineer >>> Office of Information Technology >>> University of Utah >>> marc.thompson@utah.edu >>> work 801.585.9264 >>> ------------------------------------------------------ >>> >>>>>> paul@ast.jagrove.com 05/06/05 5:56 AM >>> >>>>>> >>> Hi >>> >>> I need to send out an email from the storebuilder several hours after >>> the >>> confirmation email, is thsi possible >>> >>> When someone orders at the moment the confirmation goes out >>> immediately, >>> I >>> would like to send a second email some time later, how would I do this? >>> >>> Any help appreciated >>> >>> Thanks >>> Paul >>> >>> BTW if anyone has a Windfows license for sale contact me off list >>> please >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >> >> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> >> >> >> ------------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> To switch to the DIGEST mode, E-mail to > digest@talk.smithmicro.com> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > -- > RightCode, Inc. > 900 Briggs Road #130 > Mount Laurel, NJ 08054 > P: 856.608.7908 > F: 856.439.0154 > E: ckline@rightcode.net > > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/ > > -- ------------------------------------------- Marc Thompson Software Engineer Office of Information Technology University of Utah 801.585.9264 marc.thompson@utah.edu ------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Marc Thompson
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
show all problem (1997)
Sorting a [listdatabases] (2003)
More on the email templates (I like it) (1997)
Problems getting parameters passed into email. (1997)
[ModDate] & [ModTime] ? (1997)
[WebDNA] caret in db path? (2017)
The beginning (1997)
session handling (2004)
WebCat2b15MacPlugin - [protect] (1997)
send mail problem? (1997)
Again: tcpconnect problem with authorize.net (2003)
too many nested tags ... (1997)
Notepad problems (1998)
[WebDNA] [Test] sorry, last one (2009)
[OT] Who's got a cool link (2002)
Part Html part WebDNA (1997)
Show if time tags (1997)
Installation webCatalog (French speakers please help) (1998)
[WebDNA] Installation for Linux Dummy.. (2013)
Using Plug-In while running 1.6.1 (1997)