I learned from Robert the importance of using the <@Clearerrors> tag on all DB action and Mail actions.
This would solve your problem. They would not get the confirmation email but they wouldn't get 3 submits. You can even add code to write the error and the variables to a files so you have the information for reference. And you can build on this to have a more extensive error reporting system. Dan on 2/16/04 15:10, Roland Dumas at [EMAIL PROTECTED] wrote: > I was looking for what would cause one step to repeat multiple times > and the subsequent step not to. > > resolved: it was the following step, a mail action, that was failing. > smtp server didn't work, so client got error and they went back and hit > submit again. It kept submitting the order, but hanging at the mail > action and not deleting the user variables and shopping cart. duh. > > > > On Feb 15, 2004, at 12:37 PM, Roland Dumas wrote: > >> have had a storefront running for several months. When customer checks >> out, their order is entered into the order database and the shopping >> cart is emptied. A few days ago, we started seeing that orders were >> duplicated and triplicated in the order table. Record numbers >> incremented properly and everything. Exact dupes. >> >> No taf modifications involved. Just a new 'feature' (tripling sales!) >> >> The subsequent actions in the taf are not multiplied, just the number >> of records created. >> >> Could this be cause by corrupt database? (mySQL) ODBC? Any ideas how >> to trouble-shoot? >> >> _______________________________________________________________________ >> _ >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >> > > ________________________________________________________________________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com "When you are born, you cry and those who love you rejoice. And if you live your life as you should, when you die, you rejoice and those who love you cry." ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
