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 GromeWebDNA Solutionshttp://www.webdnasolutions.comWebDNA 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]> >> > >> > >> > >> [showif [NEWSLETTER]>0]> >> > >> [include temporary.txt],> >> [deletefile temporary.txt]> >> [writefile temporary.txt]> > > > [NEWSLETTER][/writefile]> > > >> [NEWSLETTER]> >> > >> [/showif]> >> | > >> > >>
> >> > >> [/hideif]> >> > >> [/founditems]> >> > >> [/search]> >> > >>
> >> > >>