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. > > 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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: delayed email response ( Marc Thompson 2005)
  2. Re: delayed email response ( Charles Kline 2005)
  3. Re: delayed email response ( "paul" 2005)
  4. Re: delayed email response ( "Marc Thompson" 2005)
  5. Re: delayed email response ( Gary Krockover 2005)
  6. Re: delayed email response ( "Marc Thompson" 2005)
  7. Re: delayed email response ( Gary Krockover 2005)
  8. Re: delayed email response ( "paul" 2005)
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)