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 Development WebCatalog 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:

    
  1. Re: automatically updating all records, one by one in a db (Dale 2000)
  2. Re: automatically updating all records, one by one in a db (Dale 2000)
  3. Re: automatically updating all records, one by one in a db (Peter Ostry 2000)
  4. Re: automatically updating all records, one by one in a db (WebDNA Support 2000)
  5. Re: automatically updating all records, one by one in a db (Peter Ostry 2000)
  6. automatically updating all records, one by one in a db (Dale 2000)
>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 Development WebCatalog 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)