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 WebDNAOnce the WebDNA finishes the onload will trigger to do the process again
Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@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:
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 WebDNAOnce the WebDNA finishes the onload will trigger to do the process againKind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@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)