Re: Too many lines too add in one go

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 50431
interpreted = N
texte = Try using an [append] context rather than [replace] with append=T. Then youcan dispense with the closedb [context]. And why do you create [numsold]=0only to add it to something else. And I think you should put the [append]inside the middle search, then you don't even need to create a [numsold]variable at all.Maybe this will do the trick.[search db=/db/dbase1.db&neSKUdatarq=dikkelul][founditems] [search db=/db/dbase2.db&eqOrderSKUdatarq=[SKU]][founditems][Append db=/db/topskus.db]SKU=[SKU]&sold=[OrderQTY][/Append][/founditems][/search][/founditems][/search]Regards,Tim> From: Rene van der Velde > Reply-To: (WebDNA Talk)> Date: 16 May 2003 16:08:31> To: (WebDNA Talk)> Subject: Re: Too many lines too add in one go> > 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:

Re: Too many lines too add in one go (Tim Robinson 2003)
OT: Re: Too many lines too add in one go (Rene van der Velde 2003)
Re: Too many lines too add in one go (Rene van der Velde 2003)
Re: Too many lines too add in one go (WJ Starck 2003)
Re: Too many lines too add in one go (Tim Robinson 2003)
Too many lines too add in one go (Rene van der Velde 2003)

Try using an [append] context rather than [replace] with append=T. Then youcan dispense with the closedb [context]. And why do you create [numsold]=0only to add it to something else. And I think you should put the [append]inside the middle search, then you don't even need to create a [numsold]variable at all.Maybe this will do the trick.[search db=/db/dbase1.db&neSKUdatarq=dikkelul][founditems] [search db=/db/dbase2.db&eqOrderSKUdatarq=[SKU]][founditems][Append db=/db/topskus.db]SKU=[SKU]&sold=[OrderQTY][/Append][/founditems][/search][/founditems][/search]Regards,Tim> From: Rene van der Velde > Reply-To: (WebDNA Talk)> Date: 16 May 2003 16:08:31> To: (WebDNA Talk)> Subject: Re: Too many lines too add in one go> > 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/ Tim Robinson

DOWNLOAD WEBDNA NOW!

Re: Too many lines too add in one go

2003

Top Articles:

Related Readings: