Re: Inconsistent Code

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67432
interpreted = N
texte = I would change the [Text] Variable Name to be something else... not only might it confuse you what is going on and what data is going where... but it also could confuse WebDNA. 2c [text]var_COMPID=[COMPID][/text] now change all your other references to use [var_COMPID] -- Regards, Marko On Tuesday, 13 June 2006 6:30 AM, Steve Dannaway wrote: 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/ ------------------------------------------------------------- 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)
I would change the [text] Variable Name to be something else... not only might it confuse you what is going on and what data is going where... but it also could confuse WebDNA. 2c [text]var_COMPID=[COMPID][/text] now change all your other references to use [var_COMPID] -- Regards, Marko On Tuesday, 13 June 2006 6:30 AM, Steve Dannaway wrote: 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/ ------------------------------------------------------------- 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/ Marko Bernyk

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:

maximu values for sendmail! (1997) Striping Characters (1998) [OT] Applescript (2003) Separate SSL Server (1997) Savant and WebDNA on Windows 98? (2002) Help w/Multi User Admins (1997) 2.0 Info (1997) Problems with [Applescript] (1997) weird [hideif] happenings maybe . . . (2003) change the number format (1997) Error Log.db --however (1997) pc (1997) emailer w/F2 (1997) WebCat2b13 Command Reference Doc error (1997) RE: creating writefile data from a nested search (1997) Max Record length (1997) frames & carts (1997) RAW=T..Strange behaviour (2000) NT error logs (1997) WebCat2 as a chat server? (1997)