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:

[WebDNA] [listfiles] error, but why? How to turn off (2010) OT OSX Login Problem (2006) searching with groups (1997) HELP WITH DATES (1997) Formatting an embedded search from a neebie (2000) Can't Update records (1997) Formulas.db (1997) PCS Frames (1997) Dummy Credit Card Number for debug? (1997) TCPSend / Netscape Server 4.1 (2003) WebCat2b13MacPlugIn - syntax to convert date (1997) multi-paragraph fields (1997) WebDNA Solutions ... (1997) More on the email templates (1997) carriage returns in data (1997) international time (1997) unable to launch acgi in WebCat (1997) modified storedbuilder (was: show me your store) (2003) Poll Please (2002) 2nd WebCatalog2 Feature Request (1996)