Re: [WebDNA] help with writefile

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 110059
interpreted = N
texte = No problem. Just glad it helped. :) Sincerely, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com WebDNA Programming and Linux Server Administration > Your solution worked great. > Thank you for showing me how to test for [blank] and how > to use replacefounditems. sfb > > On Dec 19, 2012, at 10:17 AM, WebDNA Solutions wrote: > > If you want to renumber only those records with a value > > in the NEWSLETTER field this should work: > > > > [search db=story.db[!] > > [/!]&neNEWSLETTERdatarq=[blank][!] > > [/!]&asNEWSLETTERsort=1[!] > > [/!]&NEWSLETTERtype=num][!] > > [/!][replacefounditems][!] > > [/!]NEWSLETTER=[index][!] > > [/!][/replacefounditems][!] > > [/!][/search] > > > > Sincerely, > > Kenneth Grome > > WebDNA Solutions > > http://www.webdnasolutions.com > > WebDNA Programming and Linux Server Administration > > > >> Hi Ken, > >> Thanks for helping me with this. > >> I've worked on it a few more hours, and I'm still > >> having difficulties. > >> > >> I've never used the [replacefounditems] tag before, > >> and I can't control what it's doing. Also, I've tried > >> a number of different numbers in place of the xxx > >> that you've placed in your search command, and I'm > >> not completely sure how that's working either. > >> > >> Each time I run your search command, the > >> [replacefounditems] tag seems to update *all* 43 of > >> the NEWSLETTER fields. I can't seem to exclude it > >> from changing the empty fields or the OFF=TRUE > >> fields. > >> > >> Here's what Im trying to do again: > >> I'm trying to search 43 fields named NEWSLETTER in a > >> > >> .db named story.db I need to ignore the records if the > >> NEWSLETTER = I need to ignore the records if the OFF > >> field = TRUE I need to renumber the NEWSLETTER field > >> from > >> > >> being > >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,16,17,18 > >> > >> to > >> > >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 > >> > >> Thank again for any input. > >> sfb > >> > >> On Dec 18, 2012, at 11:41 AM, WebDNA Solutions > > > > wrote: > >>>> You may notice that my .db file has no number 15. > >>>> I need this .db file to have these field numbers to > >>>> be contiguous. > >>> > >>> If you want consecutive numbers in the NEWSLETTER > >>> field of every record except the OFF=TRUE records, > >>> try this: > >>> > >>> [search db=story.db[!] > >>> [/!]&neSTORYNUMBERdatarq=xxx[!] > >>> [/!]&neOFFdatarq=TRUE[!] > >>> [/!]&asNEWSLETTERsort=1[!] > >>> [/!]&NEWSLETTERtype=num][!] > >>> [/!][replacefounditems][!] > >>> [/!]NEWSLETTER=[index][!] > >>> [/!][/replacefounditems][!] > >>> [/!][/search] > >>> > >>> Or if you want to include the OFF=TRUE records simply > >>> remove the third line of code above. > >>> > >>> Sincerely, > >>> Kenneth Grome > >>> WebDNA Solutions > >>> http://www.webdnasolutions.com > >>> WebDNA Programming and Linux Server Administration > >>> > >>>> Therefore, my next step was to add a > >>>> comparison between the number written to the file, > >>>> and the current number found. If they are found to > >>>> be more than one number apart, I would then execute > >>>> another step to replace the variable number. > >>>> > >>>> Unless you know of another way to reorder integer > >>>> numbers in a .db field to be in order, without > >>>> skipping any..... > >>>> > >>>> Thanks, > >>>> sfb > >>>> > >>>> On Dec 18, 2012, at 9:59 AM, WebDNA Solutions > >>> > >>> wrote: > >>>>> What are you actually trying to accomplish? You're > >>>>> repetitively writing then deleting temporary.txt > >>>>> files. Why? > >>>>> > >>>>> Sincerely, > >>>>> Kenneth Grome > >>>>> WebDNA Solutions > >>>>> http://www.webdnasolutions.com > >>>>> WebDNA Programming and Linux Server Administration > >>>>> > >>>>>> Hi All, > >>>>>> Here is my code: (I knew that you would ask) > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> [writefile temporary.txt]0[/writefile] > >>>>>>  > >>>>>>  > >>>>>> [search > >>>>>> > >>>>>> db=story.db&geSTORYNUMBERdata=1&asNEWSLETTERsort=1 > >>>>>> &N EW SL ETTERtype=num] [founditems] > >>>>>> > >>>>>> [hideif [OFF]=True] > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>> [/hideif] > >>>>>>  > >>>>>> [/founditems] > >>>>>>  > >>>>>> [/search] > >>>>>> > >>>>>>
> >>>>>> [showif [NEWSLETTER]>0] > >>>>>>  > >>>>>> [include temporary.txt], > >>>>>> [deletefile temporary.txt] > >>>>>> [writefile temporary.txt] > >>>>> > >>>>> [NEWSLETTER][/writefile] > >>>>> > >>>>>> [NEWSLETTER] > >>>>>>  > >>>>>> [/showif] > >>>>>> 
> >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> Here is my db: > >>>>>> STORYNUMBEROFFNEWSLETTER > >>>>>> 100014 > >>>>>> 100112 > >>>>>> 1002 > >>>>>> 100318 > >>>>>> 100413 > >>>>>> 100617 > >>>>>> 100716 > >>>>>> 1009 > >>>>>> 1010 > >>>>>> 1011 > >>>>>> 1012 > >>>>>> 1013 > >>>>>> 1014 > >>>>>> 1015 > >>>>>> 10169 > >>>>>> 10178 > >>>>>> 10186 > >>>>>> 101910 > >>>>>> 102011 > >>>>>> 1021 > >>>>>> 1022 > >>>>>> 10237 > >>>>>> 1024 > >>>>>> 1025 > >>>>>> 1026 > >>>>>> 1027 > >>>>>> 1028 > >>>>>> 1029 > >>>>>> 1030 > >>>>>> 1031 > >>>>>> 1032 > >>>>>> 1033 > >>>>>> 1034 > >>>>>> 1035 > >>>>>> 1036 > >>>>>> 1037 > >>>>>> 1038 > >>>>>> 1039 > >>>>>> 10405 > >>>>>> 1044TRUE > >>>>>> 1045TRUE > >>>>>> 10464 > >>>>>> 10473 > >>>>>> 10482 > >>>>>> 10491 > >>>>>> > >>>>>> Here is my result: > >>>>>> 0, 1 > >>>>>> 0, 2 > >>>>>> 0, 3 > >>>>>> 0, 4 > >>>>>> 0, 5 > >>>>>> 0, 6 > >>>>>> 0, 7 > >>>>>> 0, 8 > >>>>>> 0, 9 > >>>>>> 0, 10 > >>>>>> 0, 11 > >>>>>> 0, 12 > >>>>>> 0, 13 > >>>>>> 0, 14 > >>>>>> 0, 16 > >>>>>> 0, 17 > >>>>>> 0, 18 > >>>>>> > >>>>>> Here is my question: > >>>>>> Why won't it execute the writefile tag inside of > >>>>>> the founditems tag? > >>>>>> > >>>>>> Thank for any insight. > >>>>>> Steve Braun > >>>>> > >>>>> --------------------------------------------------- > >>>>> -- -- -- This message is sent to you because you > >>>>> are subscribed to the mailing list > >>>>> . To unsubscribe, E-mail to: > >>>>> archives: > >>>>> http://mail.webdna.us/list/talk@webdna.us Bug > >>>>> Reporting: support@webdna.us > >>>> > >>>> ---------------------------------------------------- > >>>> -- --- This message is sent to you because you are > >>>> subscribed to the mailing list . To > >>>> unsubscribe, E-mail to: > >>>> archives: http://mail.webdna.us/list/talk@webdna.us > >>>> Bug Reporting: support@webdna.us > >>> > >>> ----------------------------------------------------- > >>> -- -- This message is sent to you because you are > >>> subscribed to the mailing list . To > >>> unsubscribe, E-mail to: > >>> archives: http://mail.webdna.us/list/talk@webdna.us > >>> Bug Reporting: support@webdna.us > > > > ------------------------------------------------------- > > -- This message is sent to you because you are > > subscribed to the mailing list . > > To unsubscribe, E-mail to: > > archives: http://mail.webdna.us/list/talk@webdna.us > > Bug Reporting: support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] help with writefile (WebDNA Solutions 2012)
  2. Re: [WebDNA] help with writefile (Stephen Braun 2012)
  3. Re: [WebDNA] help with writefile (WebDNA Solutions 2012)
  4. Re: [WebDNA] help with writefile (WebDNA Solutions 2012)
  5. Re: [WebDNA] help with writefile (Stephen Braun 2012)
  6. Re: [WebDNA] help with writefile (Iphonzie 2012)
  7. Re: [WebDNA] help with writefile (WebDNA Solutions 2012)
  8. [WebDNA] help with writefile (Stephen Braun 2012)
No problem. Just glad it helped. :) Sincerely, Kenneth Grome WebDNA Solutions http://www.webdnasolutions.com WebDNA Programming and Linux Server Administration > Your solution worked great. > Thank you for showing me how to test for [blank] and how > to use replacefounditems. sfb > > On Dec 19, 2012, at 10:17 AM, WebDNA Solutions wrote: > > If you want to renumber only those records with a value > > in the NEWSLETTER field this should work: > > > > [search db=story.db[!] > > [/!]&neNEWSLETTERdatarq=[blank][!] > > [/!]&asNEWSLETTERsort=1[!] > > [/!]&NEWSLETTERtype=num][!] > > [/!][replacefounditems][!] > > [/!]NEWSLETTER=[index][!] > > [/!][/replacefounditems][!] > > [/!][/search] > > > > Sincerely, > > Kenneth Grome > > WebDNA Solutions > > http://www.webdnasolutions.com > > WebDNA Programming and Linux Server Administration > > > >> Hi Ken, > >> Thanks for helping me with this. > >> I've worked on it a few more hours, and I'm still > >> having difficulties. > >> > >> I've never used the [replacefounditems] tag before, > >> and I can't control what it's doing. Also, I've tried > >> a number of different numbers in place of the xxx > >> that you've placed in your search command, and I'm > >> not completely sure how that's working either. > >> > >> Each time I run your search command, the > >> [replacefounditems] tag seems to update *all* 43 of > >> the NEWSLETTER fields. I can't seem to exclude it > >> from changing the empty fields or the OFF=TRUE > >> fields. > >> > >> Here's what Im trying to do again: > >> I'm trying to search 43 fields named NEWSLETTER in a > >> > >> .db named story.db I need to ignore the records if the > >> NEWSLETTER = I need to ignore the records if the OFF > >> field = TRUE I need to renumber the NEWSLETTER field > >> from > >> > >> being > >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,16,17,18 > >> > >> to > >> > >> 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17 > >> > >> Thank again for any input. > >> sfb > >> > >> On Dec 18, 2012, at 11:41 AM, WebDNA Solutions > > > > wrote: > >>>> You may notice that my .db file has no number 15. > >>>> I need this .db file to have these field numbers to > >>>> be contiguous. > >>> > >>> If you want consecutive numbers in the NEWSLETTER > >>> field of every record except the OFF=TRUE records, > >>> try this: > >>> > >>> [search db=story.db[!] > >>> [/!]&neSTORYNUMBERdatarq=xxx[!] > >>> [/!]&neOFFdatarq=TRUE[!] > >>> [/!]&asNEWSLETTERsort=1[!] > >>> [/!]&NEWSLETTERtype=num][!] > >>> [/!][replacefounditems][!] > >>> [/!]NEWSLETTER=[index][!] > >>> [/!][/replacefounditems][!] > >>> [/!][/search] > >>> > >>> Or if you want to include the OFF=TRUE records simply > >>> remove the third line of code above. > >>> > >>> Sincerely, > >>> Kenneth Grome > >>> WebDNA Solutions > >>> http://www.webdnasolutions.com > >>> WebDNA Programming and Linux Server Administration > >>> > >>>> Therefore, my next step was to add a > >>>> comparison between the number written to the file, > >>>> and the current number found. If they are found to > >>>> be more than one number apart, I would then execute > >>>> another step to replace the variable number. > >>>> > >>>> Unless you know of another way to reorder integer > >>>> numbers in a .db field to be in order, without > >>>> skipping any..... > >>>> > >>>> Thanks, > >>>> sfb > >>>> > >>>> On Dec 18, 2012, at 9:59 AM, WebDNA Solutions > >>> > >>> wrote: > >>>>> What are you actually trying to accomplish? You're > >>>>> repetitively writing then deleting temporary.txt > >>>>> files. Why? > >>>>> > >>>>> Sincerely, > >>>>> Kenneth Grome > >>>>> WebDNA Solutions > >>>>> http://www.webdnasolutions.com > >>>>> WebDNA Programming and Linux Server Administration > >>>>> > >>>>>> Hi All, > >>>>>> Here is my code: (I knew that you would ask) > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> [writefile temporary.txt]0[/writefile] > >>>>>>  > >>>>>>  > >>>>>> [search > >>>>>> > >>>>>> db=story.db&geSTORYNUMBERdata=1&asNEWSLETTERsort=1 > >>>>>> &N EW SL ETTERtype=num] [founditems] > >>>>>> > >>>>>> [hideif [OFF]=True] > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>>  > >>>>>> [/hideif] > >>>>>>  > >>>>>> [/founditems] > >>>>>>  > >>>>>> [/search] > >>>>>> > >>>>>>
> >>>>>> [showif [NEWSLETTER]>0] > >>>>>>  > >>>>>> [include temporary.txt], > >>>>>> [deletefile temporary.txt] > >>>>>> [writefile temporary.txt] > >>>>> > >>>>> [NEWSLETTER][/writefile] > >>>>> > >>>>>> [NEWSLETTER] > >>>>>>  > >>>>>> [/showif] > >>>>>> 
> >>>>>> > >>>>>> > >>>>>> > >>>>>> > >>>>>> Here is my db: > >>>>>> STORYNUMBEROFFNEWSLETTER > >>>>>> 100014 > >>>>>> 100112 > >>>>>> 1002 > >>>>>> 100318 > >>>>>> 100413 > >>>>>> 100617 > >>>>>> 100716 > >>>>>> 1009 > >>>>>> 1010 > >>>>>> 1011 > >>>>>> 1012 > >>>>>> 1013 > >>>>>> 1014 > >>>>>> 1015 > >>>>>> 10169 > >>>>>> 10178 > >>>>>> 10186 > >>>>>> 101910 > >>>>>> 102011 > >>>>>> 1021 > >>>>>> 1022 > >>>>>> 10237 > >>>>>> 1024 > >>>>>> 1025 > >>>>>> 1026 > >>>>>> 1027 > >>>>>> 1028 > >>>>>> 1029 > >>>>>> 1030 > >>>>>> 1031 > >>>>>> 1032 > >>>>>> 1033 > >>>>>> 1034 > >>>>>> 1035 > >>>>>> 1036 > >>>>>> 1037 > >>>>>> 1038 > >>>>>> 1039 > >>>>>> 10405 > >>>>>> 1044TRUE > >>>>>> 1045TRUE > >>>>>> 10464 > >>>>>> 10473 > >>>>>> 10482 > >>>>>> 10491 > >>>>>> > >>>>>> Here is my result: > >>>>>> 0, 1 > >>>>>> 0, 2 > >>>>>> 0, 3 > >>>>>> 0, 4 > >>>>>> 0, 5 > >>>>>> 0, 6 > >>>>>> 0, 7 > >>>>>> 0, 8 > >>>>>> 0, 9 > >>>>>> 0, 10 > >>>>>> 0, 11 > >>>>>> 0, 12 > >>>>>> 0, 13 > >>>>>> 0, 14 > >>>>>> 0, 16 > >>>>>> 0, 17 > >>>>>> 0, 18 > >>>>>> > >>>>>> Here is my question: > >>>>>> Why won't it execute the writefile tag inside of > >>>>>> the founditems tag? > >>>>>> > >>>>>> Thank for any insight. > >>>>>> Steve Braun > >>>>> > >>>>> --------------------------------------------------- > >>>>> -- -- -- This message is sent to you because you > >>>>> are subscribed to the mailing list > >>>>> . To unsubscribe, E-mail to: > >>>>> archives: > >>>>> http://mail.webdna.us/list/talk@webdna.us Bug > >>>>> Reporting: support@webdna.us > >>>> > >>>> ---------------------------------------------------- > >>>> -- --- This message is sent to you because you are > >>>> subscribed to the mailing list . To > >>>> unsubscribe, E-mail to: > >>>> archives: http://mail.webdna.us/list/talk@webdna.us > >>>> Bug Reporting: support@webdna.us > >>> > >>> ----------------------------------------------------- > >>> -- -- This message is sent to you because you are > >>> subscribed to the mailing list . To > >>> unsubscribe, E-mail to: > >>> archives: http://mail.webdna.us/list/talk@webdna.us > >>> Bug Reporting: support@webdna.us > > > > ------------------------------------------------------- > > -- This message is sent to you because you are > > subscribed to the mailing list . > > To unsubscribe, E-mail to: > > archives: http://mail.webdna.us/list/talk@webdna.us > > Bug Reporting: support@webdna.us > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us WebDNA Solutions

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:

Formating Tables w/[founditems] (1998) Error handling for accountNum (1997) ListFiles and .DS_Store (2004) Initiating NewCart (1997) Running 2 two WebCatalog.acgi's (1996) [WebDNA] Does WebDNA run on the latest MacOS Sierra? (2016) Sku numbers (1997) WebCat for mass emailings (1997) EMail not being sent (1999) Showif -what am I missing??? (1999) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) [WebDNA] rules for naming [math] and [text] vars (2008) Getting Total Quantity (1997) Site Test Please (2005) Nested tags count question (1997) [WebDNA] User sessions - cookies only or cookies and a sessions.db? (2016) Re:WebCatalog/WebMerchant III (1998) Server slowing down. (1997) all records returned. (1997) Finding max value for a field (1997)