Re: Inconsistent Code

This WebDNA talk-list message is from

2006


It keeps the original formatting.
numero = 67435
interpreted = N
texte = [replacefounditems] doesn't apply in his case, because the replace is on a different database (events.db) than the search (carts.db)... This is,however, a perfect example of when to use a SWITCH/CASE instead of a bazillion SHOWIFs, and since the replace parameters are the same (only the data changes) for each option, I would put the data to be replaced into a text variable, then just use one REPLACE context: [switch value=[ITEM]] [case value=R1][text]DATA=RETRIEVER1STATUS=PAID[/text][/case] [case value=R2][text]DATA=RETRIEVER2STATUS=PAID[/text][/case] .... etc .... [case value=SV7][text]DATA=SUPERV7STATUS=PAID[/text][/case] [default][text]DATA=[/text] [/switch] [showif [url][DATA][/url]!] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]] [DATA][/Replace] [/showif] This is just a style choice, but it makes maintenance much easier. Also, the [waitforfile] is not being used properly - it needs an ending [/waitforfile] tag. Brian Fries BrainScan Software On Jun 12, 2006, at 9:28 PM, Gary Krockover wrote: > Also, you might look into using a [replacefounditems] context > instead of the [replace] inside of the [founditems] loop. See: > http://webdna.smithmicro.com/ref/pages.html? > context=ReplaceFoundItemsContext.html > > GJK > > > At 03:30 PM 6/12/2006, you 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!!!!! > ------------------------------------------------------------- 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)
[replacefounditems] doesn't apply in his case, because the replace is on a different database (events.db) than the search (carts.db)... This is,however, a perfect example of when to use a SWITCH/CASE instead of a bazillion SHOWIFs, and since the replace parameters are the same (only the data changes) for each option, I would put the data to be replaced into a text variable, then just use one REPLACE context: [switch value=[ITEM]] [case value=R1][text]DATA=RETRIEVER1STATUS=PAID[/text][/case] [case value=R2][text]DATA=RETRIEVER2STATUS=PAID[/text][/case] .... etc .... [case value=SV7][text]DATA=SUPERV7STATUS=PAID[/text][/case] [default][text]DATA=[/text] [/switch] [showif [url][DATA][/url]!] [Replace db=events.db&eqCOMPIDdatarq=[COMPID]&eqDOGIDdatarq=[DOGID]] [DATA][/Replace] [/showif] This is just a style choice, but it makes maintenance much easier. Also, the [waitforfile] is not being used properly - it needs an ending [/waitforfile] tag. Brian Fries BrainScan Software On Jun 12, 2006, at 9:28 PM, Gary Krockover wrote: > Also, you might look into using a [replacefounditems] context > instead of the [replace] inside of the [founditems] loop. See: > http://webdna.smithmicro.com/ref/pages.html? > context=ReplaceFoundItemsContext.html > > GJK > > > At 03:30 PM 6/12/2006, you 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!!!!! > ------------------------------------------------------------- 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/ Brian Fries

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:

NT Manual (1997) Security Question (1997) Fun with dates (1997) Trouble with formula.db (1997) all records returned. (1997) Resume Catalog ? (1997) Clickable Maps (1996) Setting up shop (1997) Bug? (1997) [WebDNA] Email time bug? YES, it's a bug! (2011) sorting and grouping (1998) taxTotal, grandTotal (1997) Updating checkboxes made easy !!! (1998) How To question on setting up downloads (1997) Setting up shop (1997) dbQuickView 2.0 (2005) Multiple catalog databases and showcart (1997) Emailer 1.01 bombs (1997) Applescript, WebDNA, and PDF (1997) Which GUI HTML editors work with WC ? (1997)