Re: [WebDNA] help with writefile

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 110039
interpreted = N
texte = > 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&NEW > >> 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 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)
> 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&NEW > >> 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 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:

WebCat and WebTV (1997) Running 2 two WebCatalog.acgi's (1996) Quick ShowIf question (1997) problems with 2 tags (1997) Mac: LModelDirector bug fix (1997) QuitFeedback & DBNotOpened errors (1997) Searching multiple fields (1997) Running 2 two WebCatalog.acgi's (1996) Sendmail error 17152 - Discovery! (2000) showif and cart (1997) Calendar (1997) authenticating a second user (1997) WebCat2 - [format thousands] (1997) [searchString] (1997) listfiles-looking for slick solution (1997) Any Newsletters out there (1998) Email notification to one of multiple vendors ? (1997) Criticism of WebCatalog: Keep It Coming! (1998) maximu values for sendmail! (1997) New Web Site Developers Database (1996)