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.=20Thanks a bunch, this will allow me to figure out when something hasnttriggered that is supose to trigger./TomOn 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:
Hot stuff, this is a brilliant idea, why didnt I think of this.=20Thanks a bunch, this will allow me to figure out when something hasnttriggered that is supose to trigger./TomOn 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)