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

Credit card types (1997) Another question (1997) Roundup function? (1997) Bug or syntax error on my part? (1997) OT: Quick poll (2003) TEXTAREA and sendmail (1998) Email template names (1997) TemplateCacheSize preference! (1998) Quitting WebMerchant ? (1997) Server Error Question [bug?] (2004) WebCatalog can't find database (1997) WebSTAR virtual roots with . in the foldername (2000) WebCat & cookies (1998) problems with 2 tags (1997) counting characters and/or words (1997) Navigator Parsing (1997) Mozilla/4. and Browser Info.txt (1997) international time (1997) Question about searching combination of fields (2003) ReturnRaw, download link for mov (2007)