Re: Trigger Problems

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38647
interpreted = N
texte = Looks valid to me. If you didn't set the NextExecute values yourself, then triggers looks like it's updating that field properly. That points to something wrong with the authentication or the template itself.Can you hit that page from a browser running on the server? Does it return in the response? Does the template take a long time to execute, more than 300 seconds? Try removing the requirement.Not that it should matter, but you can try changing your 00 to 0 in case the trigger code is confused. Try other numbers entirely, like 3, 14, or 27.Make another trigger that does something simple, like send you an email. If that works, try doing a writefile. If that works, try doing a sql statement. Use some logic and deduction skills, and you will eventually figure it out. If it doesn't work, simplify until it does and then build it back up.-Dale>This is what the triggers db looks like: > >SKU Trigger Param NextExecute Enable ExecuteURL User Pass >WasGood TimeoutSeconds RetrySeconds >1 TIME * * * * 10 00 2001/09/17 14:10:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >2 TIME * * * * 20 00 2001/09/17 14:20:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >3 TIME * * * * 30 00 2001/09/17 14:30:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >4 TIME * * * * 40 00 2001/09/17 14:40:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >5 TIME * * * * 50 00 2001/09/17 14:50:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >6 TIME * * * * 00 00 2001/09/17 14:00:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >the template dbwriter.tpl had the following: > >[SQL dsn=server&username=anyone&password=thepassword&statement=SELECT * FROM >vw_ItemFamily WHERE str_Viewable = 'Y' AND str_Active = 'Y' ORDER BY >int_Order] >[WriteFile search/maindb.txt]str_ItemNumber str_Title cur_Price >cur_SalePrice cur_ListPrice cur_MinPrice int_FamilyNumber >int_EDPNO int_Inventory int_KeyID int_Order str_Category >str_EXPECTED_DATE_1 str_SpecialShip str_ShortDesc >[foundItems][str_ItemNumber] [str_Title] [cur_Price] >[cur_SalePrice] [cur_ListPrice] [cur_MinPrice] [int_FamilyNumber] >[int_EDPNO] [int_Inventory] [int_KeyID] [int_Order] >[str_Category] [str_EXPECTED_DATE_1] [str_SpecialShip] >[str_ShortDesc] >[/foundItems][/WriteFile] >[/SQL] >Thanks.-- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Trigger Problems (Pedro Rivera 2001)
  2. Re: Trigger Problems (Dale LaFountain 2001)
  3. Re: Trigger Problems (Pedro Rivera 2001)
  4. Re: Trigger Problems (Dale LaFountain 2001)
  5. Re: Trigger Problems (Pedro Rivera 2001)
  6. Re: Trigger Problems (Dale LaFountain 2001)
  7. Trigger Problems (Pedro Rivera 2001)
  8. Re: Trigger Problems (Sara Newton 2000)
  9. Re: Trigger Problems (Kenneth Grome 2000)
  10. Trigger Problems (Sara Newton 2000)
Looks valid to me. If you didn't set the NextExecute values yourself, then triggers looks like it's updating that field properly. That points to something wrong with the authentication or the template itself.Can you hit that page from a browser running on the server? Does it return in the response? Does the template take a long time to execute, more than 300 seconds? Try removing the requirement.Not that it should matter, but you can try changing your 00 to 0 in case the trigger code is confused. Try other numbers entirely, like 3, 14, or 27.Make another trigger that does something simple, like send you an email. If that works, try doing a writefile. If that works, try doing a sql statement. Use some logic and deduction skills, and you will eventually figure it out. If it doesn't work, simplify until it does and then build it back up.-Dale>This is what the triggers db looks like: > >SKU Trigger Param NextExecute Enable ExecuteURL User Pass >WasGood TimeoutSeconds RetrySeconds >1 TIME * * * * 10 00 2001/09/17 14:10:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >2 TIME * * * * 20 00 2001/09/17 14:20:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >3 TIME * * * * 30 00 2001/09/17 14:30:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >4 TIME * * * * 40 00 2001/09/17 14:40:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >5 TIME * * * * 50 00 2001/09/17 14:50:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >6 TIME * * * * 00 00 2001/09/17 14:00:00 T >http://www.ourserver.com/dbwriter.tpl 300 10 >the template dbwriter.tpl had the following: > >[SQL dsn=server&username=anyone&password=thepassword&statement=SELECT * FROM >vw_ItemFamily WHERE str_Viewable = 'Y' AND str_Active = 'Y' ORDER BY >int_Order] >[WriteFile search/maindb.txt]str_ItemNumber str_Title cur_Price >cur_SalePrice cur_ListPrice cur_MinPrice int_FamilyNumber >int_EDPNO int_Inventory int_KeyID int_Order str_Category >str_EXPECTED_DATE_1 str_SpecialShip str_ShortDesc >[founditems][str_ItemNumber] [str_Title] [cur_Price] >[cur_SalePrice] [cur_ListPrice] [cur_MinPrice] [int_FamilyNumber] >[int_EDPNO] [int_Inventory] [int_KeyID] [int_Order] >[str_Category] [str_EXPECTED_DATE_1] [str_SpecialShip] >[str_ShortDesc] >[/foundItems][/WriteFile] >[/SQL] >Thanks.-- Dale LaFountain Vice President of Information Technology, WebMaster Dark Horse Comics, Inc. mailto:dalel@darkhorse.com Phone: 503-652-8815 x324 http://www.darkhorse.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://search.smithmicro.com/ Dale LaFountain

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:

Reversed words (1997) Protect (1997) hiding blank fields (2003) Secure server question (1997) Credit Card Checksum (1997) WebCatalog for guestbook ? (1997) emailer (1997) Cart Question (1998) Header info in content (1998) Calculating Age from DB fields (2003) Nested tags count question (1997) WebCat2_Mac RETURNs in .db (1997) RE: Forcing Paragraph Breaks on Results - Yes you can replace String for String! (1998) Secure Web Server (1999) PROTECT Q (2000) Sorting Round 2 plus (1998) [WebDNA] OT: Indexing PDF on iTools / apache2 (2008) Firesite and WebCat (1999) [WebDNA] WebDNA 7 (2011) form data submission gets truncated (1997)