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:
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)