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

Help w/ Duplicating The General Store 5 times. (1997) can WC render sites out? (1997) Form Variables (2000) BIG PROBLEMS with Checkboxes!!! (1998) Secure Server (1997) Remove WebDNA context (2001) Extended [ConvertChars] (1997) Multiple prices (1997) New Plug-in and Type 11 errors (1997) bannerads example idiot (1997) HELP WITH DATES (1997) [HTML*] (a proposition) (1997) [ListFiles] from a remote host (2003) Logic Help Needed (2003) [OT] CSS and SSI books (2004) Formulas What if. (1999) WCS Newbie question (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Generating Report Totals (1997) ShowNext (1997)