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:

writefile and deletefile (1998) pass a captured value (2004) [WebDNA] how to purge webdna cache of templates? (2009) Practice runs ? (1997) [Fwd: can we get string variables?] (1998) Dates - Search and Sorting (1999) AcountAutherizer (2002) [shownext] and descending order (1997) Requiring that certain fields be completed (1997) move files (2000) Pull down menu for categories (2000) SKU (1997) your mail (2000) Using WebCat for product info requests (1997) experts! - [foundItems] context problem (2000) search results through frames (2000) Size/Color Options (2002) Upgrading old WebCat Database Files (1997) How To question on setting up downloads (1997) Calendar using WebCatalog? (1997)