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:

E-mail/Invoice (1998) OT: Limit on # of Pulldown entries (1997) Nested tags count question (1997) Firesite and [referrer] atg broke (1997) [OT] Xserve (2002) [WebDNA] fastcgi 7+ & [cart]? (2010) Initiating NewCart (1997) using showpage and showcart commands (1996) WebCatalog on LinuxPPC (2000) Mystery authentication (1997) Ruby on Rails (was Looping Search) (2006) Emailer port change (1997) RE: Promise of future help (1998) Trouble with formula.db + more explanation (1997) RE: [WebDNA] HTTP Streaming - POSSIBLE! (2010) Housekeeping question (1999) Encrypt Users.db problem (1998) Cookie Crumble (1998) Locking up with WebCatalog... (1997) Web Catalog Instability (2000)