Re: delayed email response

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61944
interpreted = N
texte = 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/ 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)
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/ Charles Kline

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:

Shared conversion under WebTen (1998) Re:Upload (1998) Running 2 two WebCatalog.acgi's (1996) Not really WebCat- (1997) PhotoMill -> PhotoMaster (1997) Bug or syntax error on my part? (1997) [TaxableTotal] - not working with AOL and IE (1997) two unique banners on one page (1997) Searchable WebCat (etc.) Docs ? (1997) Error Msg (1998) Repeating Fields (1997) Categorizing by data (2001) Separate SSL Server (1997) [shownext] (2002) Error Log.db --however (1997) RE: [WebDNA] WebDNA & VPS (2009) [WebDNA] sem_open bugfix for os x version 6.2 (2012) Running 2 two WebCatalog.acgi's (1996) Q: writefile and uploads. (1998) So when do we get something similar? (1998)