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:

WebCat2b12 - nesting [tags] (1997) serial number generation (1997) Fulfillment e-mail? (1998) show all problem (1997) Re:Random Command (1997) Sorting by date (1997) Locking up with WebCatalog... (1997) log files (1998) WebCatalog/Mac 2.1b2 - PIXO (1997) Return records from another (1997) WebStar Secure on other machine (1997) WebCatalog2 Feature Feedback (1996) Re[2]: OT: Amazon Patents (2000) [Sum] function? (1997) feature request-- [epoch] (2004) # of real domains on 1 web server (1997) Customer - again (1998) Emailer error codes (1999) Other then credit cards-how? (1997) form data submission gets truncated (1997)