Re: Trigger Problems

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 38648
interpreted = N
texte = I'm able to hit the page from a browser and it works just fine. I've tried simple stuff on other templates and it still doesn't work.I'm going insane!!!! :o)-----Original Message----- From: Dale LaFountain [mailto:dalel@darkhorse.com] Sent: Monday, September 17, 2001 3:44 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: Trigger Problems 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/------------------------------------------------------------- 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)
I'm able to hit the page from a browser and it works just fine. I've tried simple stuff on other templates and it still doesn't work.I'm going insane!!!! :o)-----Original Message----- From: Dale LaFountain [mailto:dalel@darkhorse.com] Sent: Monday, September 17, 2001 3:44 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: Trigger Problems 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/------------------------------------------------------------- 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/ Pedro Rivera

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:

Performance Settings (2000) Bug Report, maybe (1997) New Plug-in and Type 11 errors (1997) WebCat2b15MacPlugin - showing [math] (1997) WCS Newbie question (1997) customizing the color of user's pages (1997) Banner Ad example (Typhoon) and WebCatalog (1997) webCatalog and Stocks (1998) PCS Frames (1997) Emailer (1997) Help name our technology! (1997) Question about replacing words (1998) OK, here goes... (1997) pc (1997) [ModDate] & [ModTime] ? (1997) [OT] Little Flash help (2007) FoundItems Question (1998) Calculating Shipping charges for multiple items and qtys > 1 (1997) auto-stripping of spaces (1997) Searching (2000)