Re: ReplaceFoundItems Problem
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52970
interpreted = N
texte = Justin Carroll wrote:> I'm trying to search a field of my database and replace all of the
tags with %0A. When I run this code:> > [search db=tabed.db&geskudatarq=0]> [replacefounditems]comments=[grep search=
&replace=%0A][comments][/grep][/replacefounditems]> [commitdatabase db=tabed.db]> [/search]> > ... it takes out all the
tags just fine but it doesn't replace them with the %0A. Does anyone know why this may be happening? Thanks.> A) Why are you using [search] and [replacefounditems] when your [search] is for all records. The only reason to use [replacefounditems] is when you are only hitting some records in the database.B) Why are you adding [commitdatabase] in the middle of your [search] loop? This will just make sure that the search/replace takes _much_ longer. A [replace] always does an implied [exclusivelock] at the beginning and an implied [commitdatabase] at the end.C) Always use [url]D) No, really, always use [url]!!!This should do what you want:[replace db=tabed.db&geskudatarq=0]comments=[grep search=
&replace=[url]%0A[/url]][comments][/grep][/replace]HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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:
Justin Carroll wrote:> I'm trying to search a field of my database and replace all of the
tags with %0A. When I run this code:> > [search db=tabed.db&geskudatarq=0]> [replacefounditems]comments=[grep search=
&replace=%0A][comments][/grep][/replacefounditems]> [commitdatabase db=tabed.db]> [/search]> > ... it takes out all the
tags just fine but it doesn't replace them with the %0A. Does anyone know why this may be happening? Thanks.> A) Why are you using [search] and [replacefounditems] when your [search] is for all records. The only reason to use [replacefounditems] is when you are only hitting some records in the database.B) Why are you adding [commitdatabase] in the middle of your [search] loop? This will just make sure that the search/replace takes _much_ longer. A [replace] always does an implied [exclusivelock] at the beginning and an implied [commitdatabase] at the end.C) Always use [url]D) No, really, always use [url]!!!This should do what you want:[replace db=tabed.db&geskudatarq=0]comments=[grep search=
&replace=[url]%0A[/url]][comments][/grep][/replace]HTHJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4501 Forbes BoulevardSuite HLanham, MD 20706301-459-3366 x.5010fax 301-429-5748-------------------------------------------------------------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/
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:
Webcat2, WebCommerce, Mod 10 etc. (1997)
[OT] Certs (2002)
Username for Admin Group (1997)
So what ya working on? (or have you completed?) (2004)
setting taxable to true (1997)
b12 cannot limit records returned and more. (1997)
[WebDNA] JSONStore Levels (2020)
Graphical display of sales volume (2003)
RE: Multiple Stores and WebCatalog Prefs (1997)
Error Log.db --however (1997)
Size limit for tmpl editor ? (1997)
Aaron kant add (or whatever it was) (2000)
format and math on the fly (1998)
Cart ID Duplication (2001)
required fields (1999)
Commas in search (1998)
using showpage and showcart commands (1996)
Re[3]: Re[3]: Problem with new formvariables (2000)
Bug Report, maybe (1997)
[format 40s]text[/format] doesn't work (1997)