Re: [WebDNA] triggers executed at boot instead of scheduled time

This WebDNA talk-list message is from

2011


It keeps the original formatting.
numero = 107187
interpreted = N
texte = Hot stuff, this is a brilliant idea, why didnt I think of this.=20 Thanks a bunch, this will allow me to figure out when something hasnt triggered that is supose to trigger. /Tom On Mon, 08 Aug 2011 21:44:16 -0500, Donovan Brooke wrote: > Hi Steve, >=20 > As mentioned in the trigger admin: > "The trigger will execute if it is enabled, and the NextExecute time > is earlier than the current time" >=20 > My guess is that the NextExecute had passed while your server was havin= g > issues.. >=20 > Anyway, > I don't like to rely on triggers to run code at certain times. > Instead, I wrap my code to be fired in a "time wrapper".. >=20 > ie. (code to be ran once daily) > ----------------------------------------------------------- > [if ({[time]} < {sometime}) & ({[time]} > {sometime})] > [then] > [!] ** Some solution to know if already hit today ** [/!] > [text]t_lasthit=3D[lookup=20 > db=3Dcodehit.db&lookinfield=3Dch_date&value=3D[date]&returnfield=3Dch_id&= notfound=3DNF] >=20 > [showif [t_lasthit]=3DNF] > < Run your code > >=20 > [!] ** record hit ** [/!] > [append=20 > db=3Dcodehit.db&autonumber=3DCH_ID]ch_date=3D[url][date][/url][/append] > [/showif] > [/then] > [/if] > ------------------------------------------------------------ >=20 > Then set up a trigger that fires every minute or so.. enough to > pass the initial condition a few times (for redundancy). >=20 > Hope that helps to avoid future problems. >=20 > Donovan Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] triggers executed at boot instead of scheduled time ( 2011)
  2. Re: [WebDNA] triggers executed at boot instead of scheduled time (Steve Raslevich - Northern Sound 2011)
  3. Re: [WebDNA] triggers executed at boot instead of scheduled time (Donovan Brooke 2011)
  4. [WebDNA] triggers executed at boot instead of scheduled time (Steve Raslevich - Northern Sound 2011)
Hot stuff, this is a brilliant idea, why didnt I think of this.=20 Thanks a bunch, this will allow me to figure out when something hasnt triggered that is supose to trigger. /Tom On Mon, 08 Aug 2011 21:44:16 -0500, Donovan Brooke wrote: > Hi Steve, >=20 > As mentioned in the trigger admin: > "The trigger will execute if it is enabled, and the NextExecute time > is earlier than the current time" >=20 > My guess is that the NextExecute had passed while your server was havin= g > issues.. >=20 > Anyway, > I don't like to rely on triggers to run code at certain times. > Instead, I wrap my code to be fired in a "time wrapper".. >=20 > ie. (code to be ran once daily) > ----------------------------------------------------------- > [if ({[time]} < {sometime}) & ({[time]} > {sometime})] > [then] > [!] ** Some solution to know if already hit today ** [/!] > [text]t_lasthit=3D[lookup=20 > db=3Dcodehit.db&lookinfield=3Dch_date&value=3D[date]&returnfield=3Dch_id&= notfound=3DNF] >=20 > [showif [t_lasthit]=3DNF] > < Run your code > >=20 > [!] ** record hit ** [/!] > [append=20 > db=3Dcodehit.db&autonumber=3DCH_ID]ch_date=3D[url][date][/url][/append] > [/showif] > [/then] > [/if] > ------------------------------------------------------------ >=20 > Then set up a trigger that fires every minute or so.. enough to > pass the initial condition a few times (for redundancy). >=20 > Hope that helps to avoid future problems. >=20 > Donovan

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:

WebCat2b13MacPlugIn - [showif][search][/showif] (1997) HTML Email and Images (2004) Hiding usernames and passwords in URL (1998) WebCat2 - Getting to the browser's username/password data (1997) [WebDNA] [WebDNA] WebDNA: Could not establish connection with the module (2012) Nested [tags] (2001) international time (1997) [quantity] and quantity[lineindex] (2000) WebCatalog2 Feature Feedback (1996) Date and Time Analyzer (2000) [UPPERCASE] (1997) Not really WebCat (1997) Feature Request (2003) email problem (1998) Bit off subject -- Faxing orders (1997) Frames and WebCat (1997) searchable list archive (1997) PSC recommends what date format yr 2000??? (1997) [SearchString] usage (1997) Webcat 3 Bug?!?! Netscape + Protect + Posted Form (1998)