Re: [REPLACE] inside [FOUNDITEMS]
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19194
interpreted = N
texte = At 1:29 PM -0800 7/29/98, PCS Technical Support is rumored to have typed: > >Maybe Grant can clarify this, but I don't believe that [replace] will > >change the [index] values (the positions of the rows in the db), just the > >values in the database. > > I believe you are correct. Which means [replace] would be safe, but > perhaps confusing if the side-effect of the replace is that the record no > longer matches the original search criteria, yet it still appears in the > list of found items.Just to clarify, my problem stemmed from the following (where SKU=666, INV=1):[SEARCH db=/my.db&eqSKUdatarq=666] [FOUNDITEMS] [SHOWIF [INV]>0].... [REPLACE db=my.db&eqSKUdatarq=666]INV=[MATH][INV]-1[/MATH][/REPLACE] [/SHOWIF] [HIDEIF [INV]>0]...[/HIDEIF] [/FOUNDITEMS] [/SEARCH]So, the replace caused the contents of both the [SHOWIF] *and* [HIDEIF] to be executed. I simple switch in the order of they [SHOWIF] and [HIDEIF] makes things work fine.So, there's another potential problem that could happen to someone using [REPLACE] in [FOUNDITEMS].MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet Coordinator *By web!: http://www.dhorse.com/ Dark Horse Comics, Inc. *By fax!: 503/654/9440
Associated Messages, from the most recent to the oldest:
At 1:29 PM -0800 7/29/98, PCS Technical Support is rumored to have typed: > >Maybe Grant can clarify this, but I don't believe that
[replace] will > >change the [index] values (the positions of the rows in the db), just the > >values in the database. > > I believe you are correct. Which means
[replace] would be safe, but > perhaps confusing if the side-effect of the replace is that the record no > longer matches the original search criteria, yet it still appears in the > list of found items.Just to clarify, my problem stemmed from the following (where SKU=666, INV=1):[SEARCH db=/my.db&eqSKUdatarq=666]
[founditems] [SHOWIF [INV]>0].... [REPLACE db=my.db&eqSKUdatarq=666]INV=
[math][INV]-1[/MATH][/REPLACE] [/SHOWIF] [HIDEIF [INV]>0]...[/HIDEIF] [/FOUNDITEMS] [/SEARCH]So, the replace caused the contents of both the
[showif] *and*
[hideif] to be executed. I simple switch in the order of they
[showif] and
[hideif] makes things work fine.So, there's another potential problem that could happen to someone using
[replace] in
[founditems].MichaelMichael Winston *By e-mail!: michaelw@dhorse.com Internet Coordinator *By web!: http://www.dhorse.com/ Dark Horse Comics, Inc. *By fax!: 503/654/9440
Michael Winston
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:
slightly OT: advertising schemes (2004)
WebCat2.0 acgi vs plugin (1997)
New WebDNA server (2007)
problems with 2 tags shakur (1997)
2.0 Beta (1997)
WebCat2b15MacPlugin - [protect] (1997)
upgrade? (1997)
Am on the list? (1997)
NT or Mac (1997)
WebCatalog security on NT (2000)
Web Catalog 2 demo (1997)
Card clearance, problems - solutions? (1997)
PHP vs. WebDNA (2003)
Help formatting search results w/ table (1997)
[OT] Linux Mailservers (2003)
writing orders to a db (1997)
Searchable Talklist Archive (1998)
[/application] error? (1997)
access denied problem (1997)
[QuantityPrice] Not working in WebCatNT 2.0.1??? (1997)