Re: automatically updating all records, one by one in a db
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36250
interpreted = N
texte = >You don't have to search for each record individually. [founditems] is in>fact a loop which automatically steps through all found records. Everything>between [founditems] and [/founditems] is executed record for record. You>can use [showif]'s there to define conditions for various actions. For each>run through [founditems] you can use data of the current record if>necessary.>>If you do not need individual data of the current record but rather change>all or a selection of records by given criteria, a search is not necessary.>Use [replace], which is actually query and replace in one command.>>>-->btw - to change fields within a [founditems] loop you have to use [replace]>either. Since [replace] containes a search this is (in my opinion) wasted>time - I never understood why I have to do execute a new query for a already>loaded record...Look at the new 4.0 WebDNA context called [ReplaceFoundItems]...it resolves your concern here and can speed up these kinds of updates by orders of magnitude.-- Technical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 **********************************-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>You don't have to search for each record individually. [founditems] is in>fact a loop which automatically steps through all found records. Everything>between [founditems] and [/founditems] is executed record for record. You>can use [showif]'s there to define conditions for various actions. For each>run through [founditems] you can use data of the current record if>necessary.>>If you do not need individual data of the current record but rather change>all or a selection of records by given criteria, a search is not necessary.>Use [replace], which is actually query and replace in one command.>>>-->btw - to change fields within a [founditems] loop you have to use [replace]>either. Since [replace] containes a search this is (in my opinion) wasted>time - I never understood why I have to do execute a new query for a already>loaded record...Look at the new 4.0 WebDNA context called [replacefounditems]...it resolves your concern here and can speed up these kinds of updates by orders of magnitude.-- Technical Support **********************************Smith Micro, Internet Solutions Div | eCommerce (WebCatalog)16855 West Bernardo Drive, #380 | -------------------------San Diego, CA 92127 | Software & Site DevelopmentWebCatalog Support: (858) 675-0632 | http://www.smithmicro.com Fax: (858) 675-0372 **********************************-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
WebDNA Support
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:
[WebDNA] [raw] tag with [interpret] question (2010)
Error: Can't open order file. Ignoring [OrderFile] context (2000)
Setting up shop (1997)
Searching in a range... (1998)
Securing a Directory (2000)
[URL] and [showif] or [hideif] comparisons (2003)
search engine friendly URLS (Mac) and Lycos! (1998)
Help name our technology! I found it (1997)
New public beta available (1997)
Emailer problem....still (1997)
[WebDNA] Version control (git or subversion) workflow for WebDNA (2012)
[isfile] ? (1997)
WebDNA implementation of MD5 algorithm? (2003)
[WebDNA] Searching for multiple bits of data in one field or use (2016)
japanese characters (1997)
random random links (1999)
can WC render sites out? (1997)
RE: Suggestions for Topics to be covered in an Advanced WebDNACourse... (1998)
block serving .db files (2002)
The last version of webcat (1999)