Re: [REPLACE] inside [FOUNDITEMS]
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19188
interpreted = N
texte = At 11:31 AM -0800 7/29/98, Dave MacLeay is rumored to have typed: > It's all because you're using the devil's SKU :-) > > Seriously, as far as I know, that's the way it's always worked. A [search] > generates it's own internal table of found items, idexed by their position > in the database (row #). The [founditems] context loops through that > internal table, and pulls the values from the specified row. Niether > [search] nor [founditems] have any memory (term used loosely) of the > state of these records at the time of the search.I always thought that WC would subsitute in all [FIELDNAMES] in one iteration of [FOUNDITEMS] before consulting the database again. I didn't realize that, for all intents and purposes, it does a [LOOKUP] on each [FIELDNAME]. Live and learn, I guess.> As has been discussed several times on this list, using [delete] inside > [founditems] will really screw things up. Don't even think about going > there.Yeah, I remember discovering that the hard way.Thanks! 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 11:31 AM -0800 7/29/98, Dave MacLeay is rumored to have typed: > It's all because you're using the devil's SKU :-) > > Seriously, as far as I know, that's the way it's always worked. A
[search] > generates it's own internal table of found items, idexed by their position > in the database (row #). The
[founditems] context loops through that > internal table, and pulls the values from the specified row. Niether >
[search] nor
[founditems] have any memory (term used loosely) of the > state of these records at the time of the search.I always thought that WC would subsitute in all [FIELDNAMES] in one iteration of
[founditems] before consulting the database again. I didn't realize that, for all intents and purposes, it does a
[lookup] on each [FIELDNAME]. Live and learn, I guess.> As has been discussed several times on this list, using
[delete] inside >
[founditems] will really screw things up. Don't even think about going > there.Yeah, I remember discovering that the hard way.Thanks! 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:
auto-stripping of spaces (1997)
calculating tax rates, mail order solutions and version 2 (1997)
[WebDNA] Ubuntu 14.04 LTS / Apache 2.4 (2014)
unable to launch acgi in WebCat (1997)
Stop the madness. (1997)
[WebDNA] possible bug? (db field named [width]) (2012)
Simple way to create unique SKU (1997)
Sku numbers (1997)
[WebDNA] WebDNA Roll Call (2013)
Forms Search Questions (1997)
ShowIf helper? (1998)
New commands in Final candidate (1997)
Monitoring Script (2008)
WebCat2b15MacPlugin - [protect] (1997)
Runtime (1998)
RE: ASP and Web DNA (1998)
Errata: WCS Newbie question (1997)
WebCatalog occasionally stopping (2001)
OT mod_rewrite (was urls) (2005)
Help name our technology! (1997)