Re: REPLACE & MAX/STARTAT parameters doesn't work?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 36379
interpreted = N
texte = WebCat 3.0.4b6, Mac----- Original Message -----From: John Peacock
To: WebCatalog Talk Sent: Monday, August 21, 2000 2:54 PMSubject: Re: REPLACE & MAX/STARTAT parameters doesn't work?> It's getting a little boring to say this, time after time, but here> goes again:>> WHAT O/S ARE YOU RUNNING UNDER? WHAT IS YOUR WEBCAT VERSION?>> John Peacock>> Pete 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 Ihave> > 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 fieldvalues> > 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=thisdoes> > 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 doingthis> > 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/>-------------------------------------------------------------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:
WebCat 3.0.4b6, Mac----- Original Message -----From: John Peacock To: WebCatalog Talk Sent: Monday, August 21, 2000 2:54 PMSubject: Re: REPLACE & MAX/STARTAT parameters doesn't work?> It's getting a little boring to say this, time after time, but here> goes again:>> WHAT O/S ARE YOU RUNNING UNDER? WHAT IS YOUR WEBCAT VERSION?>> John Peacock>> Pete 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 Ihave> > 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 fieldvalues> > 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=thisdoes> > 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 doingthis> > 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/>-------------------------------------------------------------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/
Pete Campbell
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:
Multiple prices (1997)
[SHOWIF AND/OR] (1997)
Pipes instead of tabs (1998)
[WebDNA] Crashing again (2008)
Webstar V and Webcatalog (2001)
Generating Report Totals (1997)
Authenticate (1997)
[OT] Java Scroller (2006)
showif field is number (1997)
PCS Frames (1997)
Frames and cart values (1998)
emailer w/F2 (1997)
Problems reading files created by WC (1997)
Sku numbers (1997)
Bug Report, maybe (1997)
Searching multiple records for certain info (2000)
japanese characters (1997)
[isfile] ? (1997)
Linux uninstall / reinstall (2003)
Help name our technology! (1997)