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:

how to use WebCat w. SSL & CyberCash (1998) Webcat 4.5.1 equivalent of autonumber (2003) multiple databases (1997) Separate SSL Server (1997) WebCatalog2 Feature Feedback (1996) Faxing orders in place of email (1997) Upgrading to 4.0 (2000) Browser / Mime Type mapping problem. (2000) [date] insanity! (2001) Limitations on fields? Server is crashing (1997) read and write you own cookies with webcat (1997) UPS went bye bye (2006) Help! WebCatalog not writing dbs to disk (2001) WebCatalog 2.0 b 15 mac (1997) Appending space (1998) [WebDNA] Protect TextArea and other Input-Fields with WebDNA (2009) [OT] JS snippet needed (2006) Denying access by IP address (2000) Emailer port change (1997) taxTotal, too (1997)