What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

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:

Server IP address? (1998) RE: OK, here goes... (1997) syntax question, not in online refernce (1997) [WebDNA] thisurlplusget and webdna v8.0.2 and v8.2 (2016) test (1998) Pithy questions on webcommerce & siteedit (1997) [WebDNA] Processor usage off the charts (2008) WebDNA and Amazon S3 (2006) math on date? (1997) [WriteFile] problems (1997) OT: Limit on # of Pulldown entries (1997) How to verify email address (1997) IE Cache Problems... (1999) Sku numbers (1997) WebTen and WebCat (1997) WC2.0 Memory Requirements (1997) RE: Languages (1997) PCS Frames (1997) Help! WebCat2 bug (1997) [WebDNA] listfiles bugs on linux (2009)