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:
Re:WebCat hosting sites? (1998)
Kaaaaahhhhhhhnnnnnnn! (1997)
Searching with a form (2000)
IIS4/WebCat3.0 Authentication (1999)
Server slowing down. (1997)
date formatting question (2001)
WebCat2 - many [carts] on one template page? (1997)
WebCat2 as a chat server? (1997)
QuitFeedback & DBNotOpened errors (1997)
Problems with [Search] param - Mac Plugin b15 (1997)
more multiple items to shopping cart (2000)
Server slowing down. (1997)
Setting up WebCatalog with Retail Pro data (1996)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
For those of you not on the WebCatalog Beta... (1997)
setting line item numbers (1998)
Search in 2 or more catalogs (1997)
Running 2 two WebCatalog.acgi's (1996)
docs for WebCatalog2 (1997)
[TaxableTotal] - not working with AOL and IE (1997)