Inconsistent Code

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67428
interpreted = N
texte = This piece of code is driving me nuts. It works about 65% of the time and the rest of the time, it either does some or none of what it's supposed to do. Does anyone see anything that might be causing this one? HELP!!!!! [!] FIND THE COMPETITOR ID FROM THE CART [/!] [search db=handlers.db&eqCARTIDdata=[ID]&max=1] [founditems] [text]COMPID=[COMPID][/text] [/founditems] [/search] [!] LOG THE PAID CART TO THE PAID DATABASE [/!] [APPEND db=carts_paid.db&AUTONUMBER=SKU]COMPID=[COMPID]&CARTID=[ID]&DATECLEARED=[DATE %m/%d/%Y][/APPEND] [commitdatabase db=carts_paid.db] [!] MARK EVENTS AS PAID IN EVENT DATABASE [/!] [search db=carts.db&eqCOMPIDdata=[COMPID]&asSKUsort=1&SKUtype=num] [founditems] [SHOWIF [ITEM]=R1] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R2] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R3] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R4] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R5] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R6] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R7] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER7STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF1] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF2] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF3] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF4] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF5] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF6] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF7] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY7STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF1A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF2A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF3A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF4A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF5A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF6A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF7A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY7STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV1] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV2] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV3] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV4] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV5] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV6] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV7] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV7STATUS=PAID[/Replace] [/SHOWIF] [commitdatabase db=events.db] [/founditems] [/search] [!] CLEAR CART FROM CARTS DATABASE [/!] [delete db=carts.db&eqCOMPIDdata=[COMPID]] [commitdatabase db=carts.db] [!] CLEAR CARTID FROM HANDLER DATABASE [/!] [Replace db=handlers.db&eqCOMPIDdata=[COMPID]&max=1]CARTID=[/Replace] [commitdatabase db=handlers.db] [!] PAUSE AND WAIT 5 SECONDS FOR ABOVE PROCESSING [/!] [waitforfile file=some_non_existent_file.txt&timeout=10] [!] REDIRECT TO PROFILE PAGE [/!] [Redirect YourProfile.tpl] ----------------------------------------- Steve Dannaway IT Director & General Counsel JM Associates, Inc. www.fishfactory.com 501-372-6544 501-416-9626 (cell) ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Inconsistent Code ( Brian Fries 2006)
  2. Re: Inconsistent Code ( Gary Krockover 2006)
  3. Re: Inconsistent Code ( Gary Krockover 2006)
  4. Re: Inconsistent Code ( Marko Bernyk 2006)
  5. Inconsistent Code ( "Steve Dannaway" 2006)
This piece of code is driving me nuts. It works about 65% of the time and the rest of the time, it either does some or none of what it's supposed to do. Does anyone see anything that might be causing this one? HELP!!!!! [!] FIND THE COMPETITOR ID FROM THE CART [/!] [search db=handlers.db&eqCARTIDdata=[ID]&max=1] [founditems] [text]COMPID=[COMPID][/text] [/founditems] [/search] [!] LOG THE PAID CART TO THE PAID DATABASE [/!] [APPEND db=carts_paid.db&AUTONUMBER=SKU]COMPID=[COMPID]&CARTID=[ID]&DATECLEARED=[DATE %m/%d/%Y][/APPEND] [commitdatabase db=carts_paid.db] [!] MARK EVENTS AS PAID IN EVENT DATABASE [/!] [search db=carts.db&eqCOMPIDdata=[COMPID]&asSKUsort=1&SKUtype=num] [founditems] [SHOWIF [ITEM]=R1] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R2] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R3] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R4] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R5] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R6] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=R7] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]RETRIEVER7STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF1] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF2] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF3] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF4] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF5] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF6] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF7] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY7STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF1A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF2A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF3A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF4A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF5A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF6A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SF7A] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERFLY7STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV1] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV1STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV2] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV2STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV3] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV3STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV4] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV4STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV5] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV5STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV6] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV6STATUS=PAID[/Replace] [/SHOWIF] [SHOWIF [ITEM]=SV7] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]]SUPERV7STATUS=PAID[/Replace] [/SHOWIF] [commitdatabase db=events.db] [/founditems] [/search] [!] CLEAR CART FROM CARTS DATABASE [/!] [delete db=carts.db&eqCOMPIDdata=[COMPID]] [commitdatabase db=carts.db] [!] CLEAR CARTID FROM HANDLER DATABASE [/!] [Replace db=handlers.db&eqCOMPIDdata=[COMPID]&max=1]CARTID=[/Replace] [commitdatabase db=handlers.db] [!] PAUSE AND WAIT 5 SECONDS FOR ABOVE PROCESSING [/!] [waitforfile file=some_non_existent_file.txt&timeout=10] [!] REDIRECT TO PROFILE PAGE [/!] [Redirect YourProfile.tpl] ----------------------------------------- Steve Dannaway IT Director & General Counsel JM Associates, Inc. www.fishfactory.com 501-372-6544 501-416-9626 (cell) ------------------------------------------------------------- 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://webdna.smithmicro.com/ "Steve Dannaway"

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:

Date Range search (1997) why is this line in GeneralStore? (1998) SSL (1998) Shop from PDF (2004) Separate SSL Server (1997) Tech support (2000) send mail problem? (1997) Can WC remember people? (1998) Error Messages Returned to User (1997) Thanks for tips, more quest (1997) Thankyou.tpl (2000) Online reference (1997) WebCat/CyberStudio Compatibility (1998) searches with dash, period etc. (2000) WebCat editing, SiteGuard & SiteEdit (1997) Problems with [Applescript] (1997) problems with 2 tags shakur (1997) sorry (1997) [TaxableTotal] - not working with AOL and IE (1997) [WebDNA] a major shift in strategy? (2008)