Re: [WebDNA] Repeated Task [reworking a DB)

This WebDNA talk-list message is from

2015


It keeps the original formatting.
numero = 112113
interpreted = N
texte = set a max of 100 and use a startat in the search and then put in an = onload to trigger a form at the bottom of the WebDNA Once the WebDNA finishes the onload will trigger to do the process again
Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 12 Feb 2015, at 5:24 am, Palle Bo Nielsen = wrote: >=20 > I am just looking for a best practise way of doing it, since I am not = looking for a manual shownext task (=E2=80=9Czzzzzzz=E2=80=9D)=E2=80=A6 >=20 > Maybe a redirect is the solution, but won=E2=80=99t it give me other = problems? Or maybe still adding to the memory challenge=E2=80=A6.? >=20 > /Palle >=20 >=20 >=20 >> On 11/02/2015, at 18.39, Terry Wilson wrote: >>=20 >> I have a client that asks for things that sometimes take down the = server. I use max=3Dx to determine what the limit is so I can at least = play around with just the first 25 records until I finalize the job. >>=20 >> You could use max=3D500 (whatever you can get away with), and use = shownext links to step through the chunks until you get them all done. I = guess you'd manually sit there and click to the next page each time, or = I guess you could set up a redirect. >>=20 >> Terry >>=20 >> On Feb 11, 2015, at 9:24 AM, Palle Bo Nielsen = wrote: >>=20 >>> Hi all >>>=20 >>> Any suggestions on how to take the value of FIELD A and change the = value and replace to into FIELD, when >>>=20 >>> - 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 >>>=20 >>> 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. >>>=20 >>> So how to repeat? Reedit to same page or? Any other good ideas? >>>=20 >>> /Palle--------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us 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)
set a max of 100 and use a startat in the search and then put in an = onload to trigger a form at the bottom of the WebDNA Once the WebDNA finishes the onload will trigger to do the process again
[thisurl]=E2=80=9D> [math][NEWSTART]+100[/MATH]=E2=80=9D>
Kind regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au > On 12 Feb 2015, at 5:24 am, Palle Bo Nielsen = wrote: >=20 > I am just looking for a best practise way of doing it, since I am not = looking for a manual shownext task (=E2=80=9Czzzzzzz=E2=80=9D)=E2=80=A6 >=20 > Maybe a redirect is the solution, but won=E2=80=99t it give me other = problems? Or maybe still adding to the memory challenge=E2=80=A6.? >=20 > /Palle >=20 >=20 >=20 >> On 11/02/2015, at 18.39, Terry Wilson wrote: >>=20 >> I have a client that asks for things that sometimes take down the = server. I use max=3Dx to determine what the limit is so I can at least = play around with just the first 25 records until I finalize the job. >>=20 >> You could use max=3D500 (whatever you can get away with), and use = shownext links to step through the chunks until you get them all done. I = guess you'd manually sit there and click to the next page each time, or = I guess you could set up a redirect. >>=20 >> Terry >>=20 >> On Feb 11, 2015, at 9:24 AM, Palle Bo Nielsen = wrote: >>=20 >>> Hi all >>>=20 >>> Any suggestions on how to take the value of FIELD A and change the = value and replace to into FIELD, when >>>=20 >>> - 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 >>>=20 >>> 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. >>>=20 >>> So how to repeat? Reedit to same page or? Any other good ideas? >>>=20 >>> /Palle--------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> archives: http://mail.webdna.us/list/talk@webdna.us >>> Bug Reporting: support@webdna.us >>=20 >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> Bug Reporting: support@webdna.us >=20 > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Stuart Tremain

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:

Umm...about those log files? (Off Topic) (1997) RE: New WebCatalog Version !!! (1997) Bug Report, maybe (1997) MacAuthorize Problem (1998) WebCat2: Items xx to xx shown, etc. (1997) Multiple download orders of the same product? (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) security (1997) WebDNA Speed Test (2008) WebCatalog for Postcards ? (1997) setting cookies for another domain? (2002) suggestion (1997) Not reading code (1997) Help name our technology! (1997) all records returned. (1997) problems with WebCat-Plugin () Duplicate Cart ID (2001) Mozilla/4. and Browser Info.txt (1997) Bad suffix error (1997) Help name our technology! I found it (1997)