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 here goes 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:

    
  1. Re: [WebDNA] REPLACE INCLUDE FILE (Michael Davis 2019)
  2. RE: [WebDNA] REPLACE INCLUDE FILE ("Terry Nair" 2019)
  3. Re: [WebDNA] REPLACE INCLUDE FILE (Stuart Tremain 2019)
  4. [WebDNA] REPLACE INCLUDE FILE (Jess Villamor 2019)
  5. Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  6. Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013)
  7. Re: [WebDNA] Replace / Append only unique data (Steve Craig 2013)
  8. Re: [WebDNA] Replace / Append only unique data ("Dan Strong" 2013)
  9. Re: [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  10. Re: [WebDNA] Replace / Append only unique data (Lawrence Banahan 2013)
  11. [WebDNA] Replace / Append only unique data (Stephen Braun 2013)
  12. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal (Donovan Brooke 2012)
  13. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal (Donovan Brooke 2012)
  14. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Stuart Tremain 2012)
  15. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Govinda 2012)
  16. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Stuart Tremain 2012)
  17. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal (Donovan Brooke 2012)
  18. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal (Donovan Brooke 2012)
  19. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Govinda 2012)
  20. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal (Donovan Brooke 2012)
  21. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Stuart Tremain 2012)
  22. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Govinda 2012)
  23. Re: [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Stuart Tremain 2012)
  24. [WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (Govinda 2012)
  25. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  26. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  27. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  28. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  29. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  30. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  31. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  32. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  33. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  34. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  35. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  36. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  37. Re: [WebDNA] CORRECTION: 60% failure rate using replace in a loop (christophe.billiottet@webdna.us 2010)
  38. [WebDNA] CORRECTION: 60% failure rate using replace in a loop (Kenneth Grome 2010)
  39. Re: [WebDNA] 60% failure rate using replace in a loop (Govinda 2010)
  40. [WebDNA] 60% failure rate using replace in a loop (Kenneth Grome 2010)
  41. Re: [WebDNA] Grep everything and replace with asterisks? ("Terry Wilson" 2010)
  42. Re: [WebDNA] Grep everything and replace with asterisks? (Govinda 2010)
  43. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  44. Re: [WebDNA] Grep everything and replace with asterisks? (Bob Minor 2010)
  45. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  46. Re: [WebDNA] Grep everything and replace with asterisks? (Marc Thompson 2010)
  47. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  48. Re: [WebDNA] Grep everything and replace with asterisks? (Marc Thompson 2010)
  49. Re: [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  50. [WebDNA] Grep everything and replace with asterisks? ("Dan Strong" 2010)
  51. Re: [WebDNA] cron - curl to replace triggers.. (Bob Minor 2009)
  52. Re: [WebDNA] cron - curl to replace triggers.. (Donovan Brooke 2009)
  53. Re: [WebDNA] cron - curl to replace triggers.. (Donovan Brooke 2009)
  54. Re: [WebDNA] cron - curl to replace triggers.. (Bob Minor 2009)
  55. [WebDNA] cron - curl to replace triggers.. (Donovan Brooke 2009)
  56. Re: replace using &append=T ( Donovan Brooke 2007)
  57. Re: replace using &append=T ( Terry Wilson 2007)
  58. Re: replace using &append=T ( Grant Hulbert 2007)
  59. Re: replace using &append=T ( sbraun 2007)
  60. Re: replace using &append=T ( Donovan Brooke 2007)
  61. Re: replace using &append=T ( Donovan Brooke 2007)
  62. Re: replace using &append=T ( matthew.bohne@benetela.com 2007)
  63. replace using &append=T ( sbraun 2007)
  64. Re: Grep -Replace with nothing ( Donovan Brooke 2003)
  65. Re: Grep -Replace with nothing ( "Rajeev Kumar" 2003)
  66. Grep -Replace with nothing ( Donovan Brooke 2003)
  67. Re: Replace Missing Images ( Tim Robinson 2003)
  68. Re: Replace Missing Images ( "Jesse Crofoot" 2003)
  69. Re: Replace Missing Images ( Paul Willis 2003)
  70. Re: Replace Missing Images ( Donovan Brooke 2003)
  71. Replace Missing Images ( "Jesse Crofoot" 2003)
  72. Re: Quick Replace Question ( Matthew A Perosi 2003)
  73. Re: Quick Replace Question ( "Andrew Simpson" 2003)
  74. Re: Quick Replace Question ( Tim Robinson 2003)
  75. Re: Quick Replace Question ( "Andrew Simpson" 2003)
  76. Re: Quick Replace Question ( Matthew A Perosi 2003)
  77. Re: Quick Replace Question ( "Andrew Simpson" 2003)
  78. Re: Quick Replace Question ( Stuart Tremain 2003)
  79. Quick Replace Question ( Matthew A Perosi 2003)
  80. Re: Replace and Autonumber ( Donovan Brooke 2003)
  81. Replace and Autonumber ( Donovan Brooke 2003)
  82. Re: multiple replace sku data (Tim Robinson 2003)
  83. Re: multiple replace sku data (kmac 2003)
  84. Re: multiple replace sku data (Matthew Bohne 2003)
  85. multiple replace sku data (kmac 2003)
  86. Re: TCPSend/Replace DB Records (Clint Davis 2002)
  87. Re: TCPSend/Replace DB Records (Donovan 2002)
  88. Re: TCPSend/Replace DB Records (Jay Van Vark 2002)
  89. Re: TCPSend/Replace DB Records (Dan Strong 2002)
  90. Re: TCPSend/Replace DB Records (Alex McCombie 2002)
  91. Re: TCPSend/Replace DB Records (Dan Strong 2002)
  92. TCPSend/Replace DB Records (Clint Davis 2002)
  93. Re: Replace and Date (Kenneth Grome 2002)
  94. Re: Replace and Date (Donovan 2002)
  95. Re: Replace and Date (Glenn Busbin 2002)
  96. Re: Replace and Date (Donovan 2002)
  97. Re: Replace and Date (Brian Fries 2002)
  98. Re: Replace and Date (Glenn Busbin 2002)
  99. Re: Replace and Date (Glenn Busbin 2002)
  100. Re: Replace and Date (Brian Fries 2002)
  101. Re: Replace and Date (Brian Boegershausen 2002)
  102. Replace and Date (Glenn Busbin 2002)
  103. Re: REPLACE and/or APPEND (Christer Olsson 2002)
  104. Re: REPLACE and/or APPEND (Jesse Williams-Proudman 2002)
  105. Re: REPLACE and/or APPEND (Gary Krockover 2002)
  106. Re: REPLACE and/or APPEND (Chris List Recipient 2002)
  107. Re: REPLACE and/or APPEND (Pedro Rivera 2002)
  108. Re: REPLACE and/or APPEND (Jesse Williams-Proudman 2002)
  109. REPLACE and/or APPEND (Chris List Recipient 2002)
  110. Re: replace urgent!!!! (Brian Fries 2001)
  111. replace urgent!!!! (Arturo Vargas 2001)
  112. Re: REPLACE & MAX/STARTAT parameters doesn't work? (WebDNA Support 2000)
  113. Re: REPLACE & MAX/STARTAT parameters doesn't work? (WebDNA Support 2000)
  114. Re: REPLACE & MAX/STARTAT parameters doesn't work? (Pete Campbell 2000)
  115. Re: REPLACE & MAX/STARTAT parameters doesn't work? (Pete Campbell 2000)
  116. Re: REPLACE & MAX/STARTAT parameters doesn't work? (Pete Campbell 2000)
  117. REPLACE & MAX/STARTAT parameters doesn't work? (Pete Campbell 2000)
  118. Re: REPLACE & MAX/STARTAT parameters doesn't work? (Michael Winston 2000)
  119. Re: REPLACE & MAX/STARTAT parameters doesn't work? (Michael Winston 2000)
  120. Re: REPLACE & MAX/STARTAT parameters doesn't work? (John Peacock 2000)
  121. Re: REPLACE & MAX/STARTAT parameters doesn't work? (John Hill 2000)
  122. Re: REPLACE & MAX/STARTAT parameters doesn't work? (John Peacock 2000)
  123. Re: append/replace and allcase=t (sorry) (Peter Ostry 2000)
  124. append/replace and allcase=t (Peter Ostry 2000)
  125. Complex replace Q-not for the timid!! (Will Starck 2000)
  126. Re: How replace title with buttons.jpg (Glenn Busbin 2000)
  127. How replace title with buttons.jpg (Dunand ADV 2000)
  128. Re: REPLACE problem (John Butler 2000)
  129. Re: REPLACE problem (WebDNA Support 2000)
  130. Re: REPLACE problem (Glenn Busbin 2000)
  131. Re: REPLACE problem (Glenn Busbin 2000)
  132. Re: REPLACE problem (WebDNA Support 2000)
  133. REPLACE problem (Glenn Busbin 2000)
  134. Re: Locked files not [REPLACE APPEND=T]ed (Grant Hulbert 2000)
  135. Locked files not [REPLACE APPEND=T]ed (Michael Winston 2000)
  136. Re: Problems with command=replace in realm (Charles Kline 2000)
  137. Re: Problems with command=replace in realm (Kenneth Grome 2000)
  138. Problems with command=replace in realm (Charles Kline 2000)
  139. Re: Replace with Producteditor.tpl (J. Danz 2000)
  140. Re: Replace with Producteditor.tpl (The Mooseman 2000)
  141. Re: Replace with Producteditor.tpl (J. Danz 2000)
  142. Re: Replace with Producteditor.tpl (The Mooseman 2000)
  143. Re: Replace with Producteditor.tpl (J. Danz 2000)
  144. Re: Replace with Producteditor.tpl (Kenneth Grome 2000)
  145. Replace with Producteditor.tpl (J. Danz 2000)
  146. Re: replace problem (Kenneth Grome 1999)
  147. Re: replace problem (listas 1999)
  148. Re: replace problem (Kenneth Grome 1999)
  149. Re: replace problem (listas 1999)
  150. Re: replace problem (Will Starck 1999)
  151. Re: replace problem (listas 1999)
  152. Re: replace problem (Will Starck 1999)
  153. replace problem (listas 1999)
  154. RE: Forcing Paragraph Breaks on Results - Yes you can replace String for String! (Olin Lagon 1998)
  155. Re: Replace context (Rob Marquardt 1998)
  156. Re: Replace context (Christer Olsson 1998)
  157. Replace context (Jeffrey L. Jones 1998)
  158. Loop context to replace items (Kelly Grady 1998)
  159. Re:Replace command help (Jay Van Vark 1998)
  160. Replace command help (Mark Anderson 1998)
  161. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Christer Olsson 1997)
  162. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Grant Hulbert 1997)
  163. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Christer Olsson 1997)
  164. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Grant Hulbert 1997)
  165. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Christer Olsson 1997)
  166. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Christer Olsson 1997)
  167. Re: Problems with ^ could be solved with [REPLACE CHARACTERS] (Grant Hulbert 1997)
  168. Problems with ^ could be solved with [REPLACE CHARACTERS] (Christer Olsson 1997)
  169. Re: Replace Statement (Damien Joldersma 1997)
  170. Re: Replace Statement (Kenneth Grome 1997)
  171. Re: Replace Statement (Grant Hulbert 1997)
  172. Re: Replace Statement (Damien Joldersma 1997)
  173. Re: Replace Statement (Kenneth Grome 1997)
  174. Replace Statement (Damien Joldersma 1997)
  175. Re: Replace context problem ... (Glenn Davis 1997)
  176. Re: Replace context problem ... (Kenneth Grome 1997)
  177. Re: Replace context problem ... (Glenn Davis 1997)
  178. Replace context problem ... and answers (Kenneth Grome 1997)
  179. Replace context problem ... (Kenneth Grome 1997)
  180. Re: Problems passing [SKU] with $Replace in 2.0 (Trevor Crist 1997)
  181. Re: Problems passing [SKU] with $Replace in 2.0 (Grant Hulbert 1997)
  182. Re: Problems passing [SKU] with $Replace in 2.0 (Kenneth Grome 1997)
  183. Problems passing [SKU] with $Replace in 2.0 (Trevor Crist 1997)
  184. Re: $Replace with [founditems] (Grant Hulbert 1997)
  185. $Replace with [founditems] (Karl Schroll 1997)
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 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)