Re: ReplaceFoundItems Problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52971
interpreted = N
texte = John, Thanks for helping me out with my problem. The answer to all of your "why"= questions is that WebDNA is new to me and I'm trying to learn it in the = best way possible. Thanks again. Justin Carroll On Friday, November 6, 1942, John Peacock wrote: >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: >>=20 >> [search db=3Dtabed.db&geskudatarq=3D0] >> [replacefounditems]comments=3D[grep >search=3D
&replace=3D%0A][comments][/grep][/replacefounditems] >> [commitdatabase db=3Dtabed.db] >> [/search] >>=20 >> ... 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. >>=20 > >A) Why are you using [search] and [replacefounditems] when your [search] = is for=20 >all records. The only reason to use [replacefounditems] is when you are = only=20 >hitting some records in the database. > >B) Why are you adding [commitdatabase] in the middle of your [search] = loop?=20 >This will just make sure that the search/replace takes _much_ longer. A=20 >[replace] always does an implied [exclusivelock] at the beginning and an = implied=20 > [commitdatabase] at the end. > >C) Always use [url] > >D) No, really, always use [url]!!! > >This should do what you want: > >[replace db=3Dtabed.db&geskudatarq=3D0]comments=3D[grep=20 >search=3D
&replace=3D[url]%0A[/url]][comments][/grep][/replace] > >HTH > >John > >--=20 >John Peacock >Director of Information Research and Technology >Rowman & Littlefield Publishing Group >4501 Forbes Boulevard >Suite H >Lanham, MD 20706 >301-459-3366 x.5010 >fax 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/ > ------------------------------------------------------------- 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:

    
  1. Re: ReplaceFoundItems Problem ( Rob Marquardt 2003)
  2. Re: ReplaceFoundItems Problem ( Brian Fries 2003)
  3. Re: ReplaceFoundItems Problem ( Justin Carroll 2003)
  4. Re: ReplaceFoundItems Problem ( John Peacock 2003)
  5. ReplaceFoundItems Problem ( Justin Carroll 2003)
John, Thanks for helping me out with my problem. The answer to all of your "why"= questions is that WebDNA is new to me and I'm trying to learn it in the = best way possible. Thanks again. Justin Carroll On Friday, November 6, 1942, John Peacock wrote: >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: >>=20 >> [search db=3Dtabed.db&geskudatarq=3D0] >> [replacefounditems]comments=3D[grep >search=3D
&replace=3D%0A][comments][/grep][/replacefounditems] >> [commitdatabase db=3Dtabed.db] >> [/search] >>=20 >> ... 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. >>=20 > >A) Why are you using [search] and [replacefounditems] when your [search] = is for=20 >all records. The only reason to use [replacefounditems] is when you are = only=20 >hitting some records in the database. > >B) Why are you adding [commitdatabase] in the middle of your [search] = loop?=20 >This will just make sure that the search/replace takes _much_ longer. A=20 >[replace] always does an implied [exclusivelock] at the beginning and an = implied=20 > [commitdatabase] at the end. > >C) Always use [url] > >D) No, really, always use [url]!!! > >This should do what you want: > >[replace db=3Dtabed.db&geskudatarq=3D0]comments=3D[grep=20 >search=3D
&replace=3D[url]%0A[/url]][comments][/grep][/replace] > >HTH > >John > >--=20 >John Peacock >Director of Information Research and Technology >Rowman & Littlefield Publishing Group >4501 Forbes Boulevard >Suite H >Lanham, MD 20706 >301-459-3366 x.5010 >fax 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/ > ------------------------------------------------------------- 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/ Justin Carroll

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:

Inprovement to listfiles ... (2003) attn: smitmicro - cart limitation (2002) shipping costs (1997) Multi-Row Tables from a search. (1997) Re:PCS Customer submissions ? (1997) Summing fields (1997) [searchString] (1997) Problems setting MIME Headers (1998) Bug? (1997) windows v4.5.1 (2003) Setting up the server (1997) Concatenating Form Variables (1998) too many nested tags ... (1997) WebTEN vs webSTAR (1998) Whats up with emailer? (1998) UPPERCASE (1997) Freeze (2003) webcat- multiple selection in input field (1997) Beta 18 (1997) Running _every_ page through WebCat-error.html (1997)