What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

OT: Re: Too many lines too add in one go

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50426
interpreted = N
texte = I hope you guys aren't from the Netherlands because you would know what dikkelul means :)On vrijdag, 16 mei 2003, Rene van der Velde wrote: >ok here she goes then :) > >if i put a max=1000 in the first search it won't time out. >i tried it without the replace, so its one of the searches that >is timing out and not the replace. >How can i put the whole thing in a loop of smaal chunks? > >dbase1 contains +/- 6000 items less than 1 mb >dbase2 contains +/- 11000 items +/-1,4MB > >and now the code..... >---------------------------------------------------------------- >[search db=/db/dbase1.db&neSKUdatarq=dikkelul] > > >[founditems] > > [search db=/db/dbase2.db&eqOrderSKUdatarq=[SKU]] > [math show=F]numsold=0[/math] > [founditems] > > [math show=f]numsold=[math]numsold[/math]+[OrderQTY][/math] > > > > [/founditems] > [/search] > >sku=[SKU], Sold=[numsold]
> >[replace >append=T&db=/db/topskus.db&eqSKUdatarq=[SKU]]sold=[numsold][/replace] > > >[/founditems] >[/search] >[closedatabase db=/db/dbase1.db] > > > >----------------------------------------------------------------- > >On vrijdag, 16 mei 2003, WJ Starck wrote: >>What are you replacing that causes a time out? >> >>This sounds a bit unusual. >> >>I'd make sure you don't have some faulty code somewhere. >> >>Other things to try: >> >>1) Increase the seconds to wait for busy database in your WebDNA prefs >>2) Add RAM (if possible) >> >>Show us a code snippet... >> >>-- >> >>Will Starck >>NovaDerm Skincare Science >>http://www.novaderm.com >>wjs@novaderm.com >> >> >>On Friday, May 16, 2003, at 05:34 AM, Tim Robinson wrote: >> >>> I would say that it depends what you are replacing. If it's possible >>> to use >>> the [replacefounditems] context, use that. You could possibly use >>> [spawn], >>> but it would help to post the appropriate code... >>> >>> Regards, >>> Tim >>> >>>> From: Rene van der Velde >>>> Reply-To: (WebDNA Talk) >>>> Date: 16 May 2003 11:59:43 >>>> To: (WebDNA Talk) >>>> Subject: Too many lines too add in one go >>>> >>>> Hello. This is probably a very newbie question but i'm a little stuck >>>> here. >>>> >>>> I'm doing a replace in a db wich times out everytime. >>>> >>>> So I need to do the replace in chunks. >>>> >>>> I've been reading up on the Loop context but it only mentiones a >>>> fixed start >>>> and end variable. The database it is reading from does not have a >>>> fixed number >>>> of items so i wouldn't know the Last end of the loop. >>>> >>>> How can I do the replace with chunks of, say 50 items ? >>>> >>>> >>>> ------------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> >> >>------------------------------------------------------------- >>This message is sent to you because you are subscribed to >> the mailing list . >>To unsubscribe, E-mail to: >>To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
I hope you guys aren't from the Netherlands because you would know what dikkelul means :)On vrijdag, 16 mei 2003, Rene van der Velde wrote: >ok here she goes then :) > >if i put a max=1000 in the first search it won't time out. >i tried it without the replace, so its one of the searches that >is timing out and not the replace. >How can i put the whole thing in a loop of smaal chunks? > >dbase1 contains +/- 6000 items less than 1 mb >dbase2 contains +/- 11000 items +/-1,4MB > >and now the code..... >---------------------------------------------------------------- >[search db=/db/dbase1.db&neSKUdatarq=dikkelul] > > >[founditems] > > [search db=/db/dbase2.db&eqOrderSKUdatarq=[SKU]] > [math show=F]numsold=0[/math] > [founditems] > > [math show=f]numsold=[math]numsold[/math]+[OrderQTY][/math] > > > > [/founditems] > [/search] > >sku=[SKU], Sold=[numsold]
> >[replace >append=T&db=/db/topskus.db&eqSKUdatarq=[SKU]]sold=[numsold][/replace] > > >[/founditems] >[/search] >[closedatabase db=/db/dbase1.db] > > > >----------------------------------------------------------------- > >On vrijdag, 16 mei 2003, WJ Starck wrote: >>What are you replacing that causes a time out? >> >>This sounds a bit unusual. >> >>I'd make sure you don't have some faulty code somewhere. >> >>Other things to try: >> >>1) Increase the seconds to wait for busy database in your WebDNA prefs >>2) Add RAM (if possible) >> >>Show us a code snippet... >> >>-- >> >>Will Starck >>NovaDerm Skincare Science >>http://www.novaderm.com >>wjs@novaderm.com >> >> >>On Friday, May 16, 2003, at 05:34 AM, Tim Robinson wrote: >> >>> I would say that it depends what you are replacing. If it's possible >>> to use >>> the [replacefounditems] context, use that. You could possibly use >>> [spawn], >>> but it would help to post the appropriate code... >>> >>> Regards, >>> Tim >>> >>>> From: Rene van der Velde >>>> Reply-To: (WebDNA Talk) >>>> Date: 16 May 2003 11:59:43 >>>> To: (WebDNA Talk) >>>> Subject: Too many lines too add in one go >>>> >>>> Hello. This is probably a very newbie question but i'm a little stuck >>>> here. >>>> >>>> I'm doing a replace in a db wich times out everytime. >>>> >>>> So I need to do the replace in chunks. >>>> >>>> I've been reading up on the Loop context but it only mentiones a >>>> fixed start >>>> and end variable. The database it is reading from does not have a >>>> fixed number >>>> of items so i wouldn't know the Last end of the loop. >>>> >>>> How can I do the replace with chunks of, say 50 items ? >>>> >>>> >>>> ------------------------------------------------------------- >>>> This message is sent to you because you are subscribed to >>>> the mailing list . >>>> To unsubscribe, E-mail to: >>>> To switch to the DIGEST mode, E-mail to >>>> >>>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>>> >>> >>> >>> ------------------------------------------------------------- >>> This message is sent to you because you are subscribed to >>> the mailing list . >>> To unsubscribe, E-mail to: >>> To switch to the DIGEST mode, E-mail to >>> >>> Web Archive of this list is at: http://webdna.smithmicro.com/ >>> >>> >> >> >>------------------------------------------------------------- >>This message is sent to you because you are subscribed to >> the mailing list . >>To unsubscribe, E-mail to: >>To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ > ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Rene van der Velde

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:

Problem with CC problem ? (1997) Checkboxes (1998) AOL and referrers on target=_blank (2000) [Sum] function? (1997) Bit off subject -- Faxing orders (1997) Wrapping text (1998) Javascript Fields of Strawberry Roses and Green Bananas (2000) WebCat2final1 crashes (1997) Quicky Date thing (2005) Encrypt broken on Mac 3.05b13?? (2000) Fwd: FW: Returned mail: you are not authorized to release queueson this server (2000) Reversed words (1997) Webcat/javascript interactive pulldowns Q [ANSWER] (2002) Searching multiple fields from one form field (1997) Help! (2000) UNSUBSCRIBE (2000) RE: [WebDNA] .htm files (2008) Trouble with Category search (2000) HTML encoding in URLs (1997) [OT] JS Libraries (2007)