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:

More than one db with the same namn (was: WC2f3) (1997) Configuring E-mail (1997) Stopping bad HTML propagation ? (1997) iTools and 3.0.8 (2000) [include ...] behavior (1997) Ampersand (1997) Opinion: [input] should be called [output] ... (1997) Major Security Hole IIS NT (1998) Date fun with MySQL (2004) Weird bug, or is there something amiss? (1997) WebMerchant? (1998) %@#*& back button!!! (1999) Replace context (1998) PSC recommends what date format yr 2000??? (1997) Site Builder & IE Mac (2004) Setting up WebCatalog with Retail Pro data (1996) Bad creator codes which cause access denied errormessage (1997) Bug in WebCat, (2000) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Blowback and budgets. (2000)