Re: Multiple edits/replacementsd to db. Possible?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15783
interpreted = N
texte = >Perhaps third time is a charm. I could really use an answer to this.>Is there a way to do multiple replaces to the db. I want to be able to >find a list of products, say all by one vendor or artist, and mark them >as on sale. Hi Jerry,Grant already answered this question, I remember reading his response. I think I answered it, too. Did you read his (or our) response(s)?The answer, once again, is YES, you can replace a whole bunch of data in a whole bunch of records, all at the same time!All you have to do is write the *search portion* of your replace context so that it retrieves *exactly* the records you want to replace data in, and it will replace every one of the field values with the new values you tell it to replace -- in ALL those records, all at once.Please refer to the HTML docs and/or the .pfd docs, they both explain this procedure. Also, take a look at the list archives to see Grant's answer, I think he explained it pretty well, too ... :)Sincerely, Ken Grome ken@iav.com 808-737-6499 WebDNA Solutions http://webdna.net/
Associated Messages, from the most recent to the oldest:
>Perhaps third time is a charm. I could really use an answer to this.>Is there a way to do multiple replaces to the db. I want to be able to >find a list of products, say all by one vendor or artist, and mark them >as on sale. Hi Jerry,Grant already answered this question, I remember reading his response. I think I answered it, too. Did you read his (or our) response(s)?The answer, once again, is YES, you can replace a whole bunch of data in a whole bunch of records, all at the same time!All you have to do is write the *search portion* of your replace context so that it retrieves *exactly* the records you want to replace data in, and it will replace every one of the field values with the new values you tell it to replace -- in ALL those records, all at once.Please refer to the HTML docs and/or the .pfd docs, they both explain this procedure. Also, take a look at the list archives to see Grant's answer, I think he explained it pretty well, too ... :)Sincerely, Ken Grome ken@iav.com 808-737-6499 WebDNA Solutions http://webdna.net/
Kenneth Grome
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:
CSS and SSI books (2004)
rotating thumbnails (1997)
Maillist content (was WebDNA for Dummies) (2004)
verify online (1997)
User Authentication (2003)
[WebDNA] Sendmail BCC bug still exists (2015)
The evolved Server Configuration Queston (2000)
How do I specify a & character in Grep? (2000)
New Plug-in and Type 11 errors (1997)
Will webdna execute before a [redirect]? (1999)
Sub Totals (2000)
hideif/showif causes error if wrapped around searches (2003)
formulas.db ?? (1998)
Problems adding stuff to the shopping cart. (1997)
WebCat cannot handle compatible search parameters? (1997)
Problems with [Applescript] (1997)
New Guestbook Source (1997)
b12 cannot limit records returned and more. (1997)
WebDNA within the shell (2004)
OK, here goes... (1997)