Re: REPLACE & MAX/STARTAT parameters doesn't work?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36371
interpreted = N
texte = It's getting a little boring to say this, time after time, but heregoes again:WHAT O/S ARE YOU RUNNING UNDER? WHAT IS YOUR WEBCAT VERSION?John PeacockPete Campbell wrote:> > The WC manual says that the REPLACE search parameters work exactly like> Search command or [Search], but this doesn't appear to be true when I have> MAX=x and/or STARTAT=y parameters in my REPLACE statement.> > So far, the only way I have been able to perform a REPLACE of a specific> search that uses MAX/STARTAT is to use a SEARCH context with these> parameters, then use a REPLACE context that matches all of the field values> found in the search. For example...> > ************> > [!] This should replace the 3rd instance of USERID but it replaces ALL> instances of USERID [/!]> [REPLACE db=test.db&eqUSERIDdatarq=[userid]&startat=3&max=1]value=this does> not work[/replace]> > [!] This is the workaround/kludge I have to use [/!]> [search db=test.db&eqUSERIDdatarq=[userid]&startat=3&max=1]> [founditems]> [replace> db=test.db&eqUSERIDdatarq=[userid]&eqFIELD1datarq=[field1]...&eqFIELD99datar> q=[field99]]value=this does work[/replace]> [founditems]> [/search]> > ************> > So either this is a bug in WC, or the manual is wrong, or I am doing this> incorrectly. Thoughts, solutions?> > Thanks> > Pete> > -------------------------------------------------------------> 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://search.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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
It's getting a little boring to say this, time after time, but heregoes again:WHAT O/S ARE YOU RUNNING UNDER? WHAT IS YOUR WEBCAT VERSION?John PeacockPete Campbell wrote:> > The WC manual says that the REPLACE search parameters work exactly like> Search command or [search], but this doesn't appear to be true when I have> MAX=x and/or STARTAT=y parameters in my REPLACE statement.> > So far, the only way I have been able to perform a REPLACE of a specific> search that uses MAX/STARTAT is to use a SEARCH context with these> parameters, then use a REPLACE context that matches all of the field values> found in the search. For example...> > ************> > [!] This should replace the 3rd instance of USERID but it replaces ALL> instances of USERID [/!]> [REPLACE db=test.db&eqUSERIDdatarq=[userid]&startat=3&max=1]value=this does> not work[/replace]> > [!] This is the workaround/kludge I have to use [/!]> [search db=test.db&eqUSERIDdatarq=[userid]&startat=3&max=1]> [founditems]> [replace> db=test.db&eqUSERIDdatarq=[userid]&eqFIELD1datarq=[field1]...&eqFIELD99datar> q=[field99]]value=this does work[/replace]> [founditems]> [/search]> > ************> > So either this is a bug in WC, or the manual is wrong, or I am doing this> incorrectly. Thoughts, solutions?> > Thanks> > Pete> > -------------------------------------------------------------> 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://search.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://search.smithmicro.com/
John Peacock
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:
OT-ssh help (2004)
Validation (2000)
select multiple 2 more cents (1997)
Documentation Feedback (1997)
WebCat2b13MacPlugIn - [include] (1997)
off-topic - printinglib 68K (1997)
WebCat2 - Getting to the browser's username/password data (1997)
Show next 2 examples that work (1997)
Problem getting shipping to calculate (2003)
Help! WebCat2 bug (1997)
P1: How to make webcatalog more stable. - LONG (1999)
[foundItems] context question --returns some fields but not others-- (2000)
New command suggestion (1997)
Secure server question (1997)
database paths/names, and a typo (1997)
Pull Down Search (2000)
RE: Web*SSL and WebCatalog (1997)
WebCat2 - [format thousands] (1997)
Summing fields (1997)
notification solutions (1997)