Re: [REPLACE] inside [FOUNDITEMS]
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 19202
interpreted = N
texte = At 14:29 Uhr 29.07.1998, PCS Technical Support wrote:>>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. Hm. I got confused while watching this thread... I don't think we can see [Replace] generally as a lookup. A lookup looks for the first field which matches the request, but [Replace] is supposed to change a lot of records at once. Fine thing, but what if you do a replace for a certain record while in [founditems] and it actually changes five other records which are probably already processed? For my personal feeling [Replace] seems to be save when you have a unique ID and use just this value as main parameter for [Replace]. But - personal feeling again - I won't rely on that... Every programmer develops his personal style over time. For me, I never ever give my program the chance to replace more than one record or delete records from the same selection where I'm in at the moment. And I won't start a new search within the same selection, unless the software has commands like push on stack to secure the current record (or the ability to save selections).However, a possibility to change fields of the current record would make this whole discussion obsolete - isn't that a daily job for such an application? Any database can go to one record, change some values and save the record. WebCat can do this in a cart, but not in a database - why?I don't ask for something complicated, just for something like that: [SetField field=DESCRIPTION&value=good stuff] which changes one field of the current record... Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
At 14:29 Uhr 29.07.1998, PCS Technical Support wrote:>>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. Hm. I got confused while watching this thread... I don't think we can see
[replace] generally as a lookup. A lookup looks for the first field which matches the request, but
[replace] is supposed to change a lot of records at once. Fine thing, but what if you do a replace for a certain record while in
[founditems] and it actually changes five other records which are probably already processed? For my personal feeling
[replace] seems to be save when you have a unique ID and use just this value as main parameter for
[replace]. But - personal feeling again - I won't rely on that... Every programmer develops his personal style over time. For me, I never ever give my program the chance to replace more than one record or delete records from the same selection where I'm in at the moment. And I won't start a new search within the same selection, unless the software has commands like push on stack to secure the current record (or the ability to save selections).However, a possibility to change fields of the current record would make this whole discussion obsolete - isn't that a daily job for such an application? Any database can go to one record, change some values and save the record. WebCat can do this in a cart, but not in a database - why?I don't ask for something complicated, just for something like that: [SetField field=DESCRIPTION&value=good stuff] which changes one field of the current record... Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
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:
[showif] or-ing (1999)
Listserver problem (1997)
sendmail and accented characters (1998)
DON'T use old cart file! (1997)
RE: NewCart+Search with one click ? (1997)
won't serve .tpl -permissions (2000)
[WebDNA] MD5 Hash issue (2009)
Web Catalog vs. ICAT (1997)
WebCat odd log behavior (1998)
A dynamic database. (1997)
Summarising on two fields (1998)
[WebDNA] =?windows-1252?Q?Re=3A_=5BWebDNA=5D_Anyone_got_Panic_CODA_2_up_a?= (2013)
can WC render sites out? (1997)
[writefile] remotely (2000)
Emailer choke (1997)
Setting Cart value (2000)
How to include weather (2000)
Emailer, SMTP Server, Prefs (2006)
Emailer help....! (1997)
How to Display text in empty fields (1997)