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:
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:
process SSI (1998)
[OT] Industry news from Australia (2000)
[WebDNA] test email (2014)
Running 2 two WebCatalog.acgi's (1996)
TcpConnect get files on ver. 5.x BUG BUG BUG (2004)
Protect (1997)
[WebDNA] Protect TextArea and other Input-Fields with WebDNA (2009)
[OT]R E: [WebDNA] UPS integration (2010)
Listfiles on network with NT (2000)
Username for Admin Group (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Setting up shop (1997)
Emailer setup (1997)
boldwords funky (1998)
PCS Customer submissions ? (1997)
Apache suffix mapping for .tpl (2000)
More on the email templates (1997)
WebDNA and ASP on Same Server (2004)
One more time (1997)
MY SOLUTION.... Send massmail (2000)