Re: Trigger Problems

This WebDNA talk-list message is from

2001

It keeps the original formatting. numero = 38646
interpreted = N
texte = This is what the triggers db looks like: SKU Trigger Param NextExecute Enable ExecuteURL User PassWasGood TimeoutSeconds RetrySeconds1 TIME * * * * 10 00 2001/09/17 14:10:00 Thttp://www.ourserver.com/dbwriter.tpl 300 102 TIME * * * * 20 00 2001/09/17 14:20:00 Thttp://www.ourserver.com/dbwriter.tpl 300 103 TIME * * * * 30 00 2001/09/17 14:30:00 Thttp://www.ourserver.com/dbwriter.tpl 300 104 TIME * * * * 40 00 2001/09/17 14:40:00 Thttp://www.ourserver.com/dbwriter.tpl 300 105 TIME * * * * 50 00 2001/09/17 14:50:00 Thttp://www.ourserver.com/dbwriter.tpl 300 106 TIME * * * * 00 00 2001/09/17 14:00:00 Thttp://www.ourserver.com/dbwriter.tpl 300 10the template dbwriter.tpl had the following:[SQL dsn=server&username=anyone&password=thepassword&statement=SELECT * FROMvw_ItemFamily WHERE str_Viewable = 'Y' AND str_Active = 'Y' ORDER BYint_Order][WriteFile search/maindb.txt]str_ItemNumber str_Title cur_Pricecur_SalePrice cur_ListPrice cur_MinPrice int_FamilyNumberint_EDPNO int_Inventory int_KeyID int_Order str_Categorystr_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.-----Original Message-----From: Dale LaFountain [mailto:dalel@darkhorse.com]Sent: Monday, September 17, 2001 2:48 PMTo: WebDNA-Talk@talk.smithmicro.comSubject: Re: Trigger ProblemsTo do this with webcat triggers, you would need six trigger entries. This is because you can't specify intervals or multiple values in the minutes field.Does the template execute when you hit it with a browser?Again, if you post the trigger entry you're trying to set up, we could probably be more specific in our assistance...-Dale>What we're trying to accomplish with the triggers, is to have a database>file be re-written every 10 minutes. I thought that the trigger would do it>but I can't even get them to do anything at all.>>If anyone has triggers working for you let me know how...>>Thanks.-- Dale LaFountainVice President of Information Technology, WebMasterDark Horse Comics, Inc. mailto:dalel@darkhorse.comPhone: 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 toWeb 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:

Re: Trigger Problems (Pedro Rivera 2001) Re: Trigger Problems (Dale LaFountain 2001) Re: Trigger Problems (Pedro Rivera 2001) Re: Trigger Problems (Dale LaFountain 2001) Re: Trigger Problems (Pedro Rivera 2001) Re: Trigger Problems (Dale LaFountain 2001) Trigger Problems (Pedro Rivera 2001) Re: Trigger Problems (Sara Newton 2000) Re: Trigger Problems (Kenneth Grome 2000) Trigger Problems (Sara Newton 2000)

This is what the triggers db looks like: SKU Trigger Param NextExecute Enable ExecuteURL User PassWasGood TimeoutSeconds RetrySeconds1 TIME * * * * 10 00 2001/09/17 14:10:00 Thttp://www.ourserver.com/dbwriter.tpl 300 102 TIME * * * * 20 00 2001/09/17 14:20:00 Thttp://www.ourserver.com/dbwriter.tpl 300 103 TIME * * * * 30 00 2001/09/17 14:30:00 Thttp://www.ourserver.com/dbwriter.tpl 300 104 TIME * * * * 40 00 2001/09/17 14:40:00 Thttp://www.ourserver.com/dbwriter.tpl 300 105 TIME * * * * 50 00 2001/09/17 14:50:00 Thttp://www.ourserver.com/dbwriter.tpl 300 106 TIME * * * * 00 00 2001/09/17 14:00:00 Thttp://www.ourserver.com/dbwriter.tpl 300 10the template dbwriter.tpl had the following:[SQL dsn=server&username=anyone&password=thepassword&statement=SELECT * FROMvw_ItemFamily WHERE str_Viewable = 'Y' AND str_Active = 'Y' ORDER BYint_Order][WriteFile search/maindb.txt]str_ItemNumber str_Title cur_Pricecur_SalePrice cur_ListPrice cur_MinPrice int_FamilyNumberint_EDPNO int_Inventory int_KeyID int_Order str_Categorystr_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.-----Original Message-----From: Dale LaFountain [mailto:dalel@darkhorse.com]Sent: Monday, September 17, 2001 2:48 PMTo: WebDNA-Talk@talk.smithmicro.comSubject: Re: Trigger ProblemsTo do this with webcat triggers, you would need six trigger entries. This is because you can't specify intervals or multiple values in the minutes field.Does the template execute when you hit it with a browser?Again, if you post the trigger entry you're trying to set up, we could probably be more specific in our assistance...-Dale>What we're trying to accomplish with the triggers, is to have a database>file be re-written every 10 minutes. I thought that the trigger would do it>but I can't even get them to do anything at all.>>If anyone has triggers working for you let me know how...>>Thanks.-- Dale LaFountainVice President of Information Technology, WebMasterDark Horse Comics, Inc. mailto:dalel@darkhorse.comPhone: 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 toWeb 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:

Checking for blank form fields 2nd idea (1998) Stopping bad HTML propagation ? (1997) Ampersand (1997) [append] vs. [appendfile] delta + question? (1997) eChecks (2000) Protect vs Authenicate (1997) expired beta (1997) Configuring E-mail (1997) Documentation Feedback (1997) [WebDNA] Handy (2009) WCf2 and nested tags (1997) Closing Databases (1998) Shipping Calculation Problem (1997) Problems passing [SKU] with $Replace in 2.0 (1997) Associative lookup style? + bit more (1997) [WebDNA] Search Problem (2011) Unable to append (2001) Running _every_ page through WebCat ? (1997) Adding up weights (1998) WC1.6 to WC2 date formatting (1997)