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:
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:
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Most Efficiant Way to do restricted Areas (1997)
Credit card processing - UK (1997)
carriage returns in data (1997)
back button problem (1999)
can WC render sites out? (1997)
OT: test ... (2004)
Problems with 2.1b4 (1997)
[DOS]/DOS query perhaps OT (2003)
Database Options (1997)
Image upload (2000)
[math] storage of variables (1997)
WebMerchant issues. (2000)
TaxTotal Problem (1997)
WebCat2 - [format thousands] (1997)
Quick Question About Sorting (1997)
one item in several different categories? (2000)
Pithy questions on webcommerce & siteedit (1997)
Multiple Pulldowns (1997)
Robots fill event log (1997)