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 = 36254
interpreted = N
texte = I can't run 4.0 - it crashes and burns on my server. :(On Friday, August 18, 2000, WebDNA Support wrote: >>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.------------------------------------------------------------- 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)
I can't run 4.0 - it crashes and burns on my server. :(On Friday, August 18, 2000, WebDNA Support wrote: >>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.------------------------------------------------------------- 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/ Dale

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:

Payflow Pro on OSX (2003) A question on sub-categories (1997) NT License trade for Mac (2000) [WebDNA] AJAX module (2012) Doing VALIDCARD right? (1998) Help! WebCat2 bug (1997) Mac Vs WindowsNT (1997) quantity minimum problem (1997) t or f (1997) Mass Mail (2000) newbie ?: splitting webcat files between ssl and non-ssl sites (1999) purchase.log file (1997) price carry over (1997) Adding To items to cart at once (1999) Possible Bug in 2.0b15.acgi (1997) MacAuthorize order data fields WAS:How To question... (1997) Plugin or CGI or both (1997) One more time (1997) Using Plug-In while running 1.6.1 (1997) authorizenet (2001)