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 oneiteration of [FOUNDITEMS] before consulting the database again. I didn'trealize 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.comInternet 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 oneiteration of
[founditems] before consulting the database again. I didn'trealize 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.comInternet 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:
Suffix Mapping (1997)
Adding a donation amount (2000)
WebCat2 - Getting to the browser's username/password data (1997)
Formatting dates stored in db (2003)
Week # problem (1998)
ListFiles then delete by ModDate (2002)
Calendar using WebCatalog? (1997)
How To (2003)
[WebDNA] Populating a menu from a search (2016)
[SearchString] problem with [search] context (1997)
Input and Convertchars contexts (2003)
Locking up with WebCatalog... (1997)
Tool of Use to Unix WebCat Admins (2000)
Information on Vieworders.tpl (1998)
Re[3]: Problem with new formvariables (2000)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
Price Change Password (2003)
Running 2 two WebCatalog.acgi's (1996)
cannot delete last admin (1999)
Document Contains no data, or showcart error. (1997)