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:
Separate server for jpg/gif files (1998)
2 easy questions re: [showif] and [sendmail] (1997)
[WebDNA] Mac OS X 10.9.2 Webdna Installation Instructions (2014)
Reindexing a db with duplicate numbers... (1999)
[encrypt] blues.... (2000)
Webmerch Error (1998)
More questions about serial number dishing (1997)
Removing [showif] makes a big difference in speed (1997)
Logging purchases (1997)
WebCat2 - [format thousands] (1997)
[createfolder] & [deletefolder] (1997)
Bug Report, maybe (1997)
Header info in content (1998)
unable to launch acgi in WebCat (1997)
[WebDNA] Last WSC shares for sale! (2009)
AutoCommit Preference? (1998)
[protect admin] (1997)
WebCatalog for Postcards ? (1997)
How can I Add several Items into the cart at once? (1997)
Trouble with Netscape (1998)