[WebDNA] Repeated Task [reworking a DB)

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112106
interpreted = N
texte = Hi all Any suggestions on how to take the value of FIELD A and change the value = and replace to into FIELD, when - when FIELD A is a CART value which can be between 13 and 18 chars - and the result must end up being the the first 13 chars - and the DB consist of 1 million rows I have no problem in identifying FIELD A and changing it to the new = VALUE in FIELD B nor replacing it into the database. My problem is that = if I just kick off the script it take down the server. So it needs to = take it in chunks of ex. 500 unit. So how to repeat? Reedit to same page or? Any other good ideas? /Palle= Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Repeated Task [reworking a DB) (Stuart Tremain 2015)
  2. Re: [WebDNA] Repeated Task [reworking a DB) (Kenneth Grome 2015)
  3. Re: [WebDNA] Repeated Task [reworking a DB) (Palle Bo Nielsen 2015)
  4. Re: [WebDNA] Repeated Task [reworking a DB) (Kenneth Grome 2015)
  5. Re: [WebDNA] Repeated Task [reworking a DB) (Palle Bo Nielsen 2015)
  6. Re: [WebDNA] Repeated Task [reworking a DB) (Terry Wilson 2015)
  7. [WebDNA] Repeated Task [reworking a DB) (Palle Bo Nielsen 2015)
Hi all Any suggestions on how to take the value of FIELD A and change the value = and replace to into FIELD, when - when FIELD A is a CART value which can be between 13 and 18 chars - and the result must end up being the the first 13 chars - and the DB consist of 1 million rows I have no problem in identifying FIELD A and changing it to the new = VALUE in FIELD B nor replacing it into the database. My problem is that = if I just kick off the script it take down the server. So it needs to = take it in chunks of ex. 500 unit. So how to repeat? Reedit to same page or? Any other good ideas? /Palle= Palle Bo Nielsen

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:

Only charge card when product shipped ? (1997) [referrer] tag (1997) Emailer error 550? (1999) Calendar using WebCatalog? (1997) Mozilla/4. and Browser Info.txt (1997) RSS Reader - WebDNA (2007) Associative lookup style? + bit more (1997) blank page from template (1997) Server Load (2000) Help! WebCat2 bug (1997) [showif],[refferer],[include] in errormessages.db (2002) AppleScript: Tell application:app location? (1998) WebCatalog/WebMerchant 2.1 (1998) PCS Frames (1997) Unix DB Permission Error (2002) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) relogin same user? (1998) WC1.6 to WC2 date formatting (1997) hmmm (2006) Founditems context returning only 1 item (1997)