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.ID
TIMESTAMPSENT_STATUSSEND_TOSUBJECTMSG_BODYYou 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=TAll done.- CharlesOn 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 #130Mount Laurel, NJ 08054P: 856.608.7908F: 856.439.0154E: 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:
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_BODYYou 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=TAll done.- CharlesOn 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 #130Mount Laurel, NJ 08054P: 856.608.7908F: 856.439.0154E: 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)