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:
[TaxableTotal] - not working with AOL and IE (1997)
Verifying and adding new users (1997)
page chokes on hideif when false and ignored (1998)
WebMerchant and PCAuthorize (1998)
NT Manual (1997)
Emailer help....! (1997)
problems with 2 tags (1997)
Showing unopened cart (1997)
Emailer (1997)
Here we go again... (2006)
Field validation problem (1999)
Mac app. that converts e-mails (2000)
Running _every_ page through WebCat-error.html (1997)
Linux ODBC and the ODBC Bridge (2000)
changing creator codes (2000)
removing programming logic white space (2003)
List Address Changed! (1998)
[SearchString] usage (1997)
format_to_days on NT (1997)
Copyright ? (1997)