Re: ReplaceFoundItems Problem

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52972
interpreted = N
texte = I think you were actually on the right track with the search and replaceitems... Without this, you don't have access to the record-specific "comments" field for your grep, and all your records will end up with a "comments" value of "[comments]". Are you wanting the actual text "%0A" to be inserted in the DB, or the LF character that %0A represents? If you want %0A, then change your grep replace to [url]%0A[/url], as John suggested. If you want the LF character, I think you're out of luck, as I believe WebDNA will strip that when writing to the db. - brian On Thursday, September 18, 2003, at 11:17 AM, Justin Carroll wrote: > 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: >>> >>> [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] >> >> HTH >> >> John >> >> -- >> 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 > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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)
I think you were actually on the right track with the search and replaceitems... Without this, you don't have access to the record-specific "comments" field for your grep, and all your records will end up with a "comments" value of "[comments]". Are you wanting the actual text "%0A" to be inserted in the DB, or the LF character that %0A represents? If you want %0A, then change your grep replace to [url]%0A[/url], as John suggested. If you want the LF character, I think you're out of luck, as I believe WebDNA will strip that when writing to the db. - brian On Thursday, September 18, 2003, at 11:17 AM, Justin Carroll wrote: > 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: >>> >>> [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] >> >> HTH >> >> John >> >> -- >> 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 > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/ Brian Fries

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:

using showpage and showcart commands (1996) [ShowNext] (1997) Ken's Data Manager (was dbQuickView 2.0) (2005) World Address Info (2003) Nested tags count question (1997) Help!!!! (1999) Question about replacing words (1998) Weird happenings (1998) [ShowNext] (1997) What Country (2004) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) WebCommerce Security Alert! (1996) Looking for a host (1997) cart info (1998) Date Problems (2000) Viewing old carts (was FEW QUESTIONS) (1997) CORR: date format (2000) Navigator 4.01 (1997) Emailer freezes under OSX (2003) How do I get data out of an Orderfile... (2001)