Re: [WebDNA] [append] does not add the newline char at the end of
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103346
interpreted = N
texte = John Butler wrote:>> John Butler wrote:>>> Version=6.1>>> PLATFORM=unix-Linux Intel RedHat>>> I have a problem that is forcing me to think of creative workarounds >>> for today's code, but more than that is disturbing in general:>>> I have a perfectly normal and working [append] context.. but it is >>> not ending the record it appends with a newline char. I've seen >>> that before, but just decided to myself that it must be OK (even >>> though a faint voice said it was not supposed to be that way). Once >>> I append another record, then the previous record does get it's >>> delimiting newline char.>>> Well now I am doing a *simple* search on this db, and it finds any >>> specific one record I tell it to find, UNLESS I am trying to find >>> that last record with no newline char at the end. If I manually add >>> the newline char at the end, then the search works as expected.>>> Has anyone had any such experience? Suggestions?>>>> I'm a bit confused at what you are asking.. but>> I would definitely update your "6.1" version to "6.2".>>>> Not sure what release that is that you are using, because we>> didn't officially release a "6.1" version.>>>> Re: your append, maybe post some code?.. and maybe>> a more terse description of what is going on?>>>> Donovan> > This code:> > Version=[version]> PLATFORM=[PLATFORM]> > returns this:> Version=6.1> PLATFORM=unix-Linux Intel RedHat> > I would LOVE to update the release, but this is on a shared host. I > will put in a request.. but the webdna man there is on honeymoon... so > it won't happen now. Meanwhile I have to produce for the client now.> > ----------------> > this code:> > [Append > db=^dir/mydb.db]field1=123&field2=[url][val][/url]...&field24=none_yet[/Append] > > > successfully and accurately writes to mydb.db. It writes the new > record which I just asked it to. * BUT * this new record does NOT have > a newline char at the end... UNTIL / UNLESS I [append] another record.> > So what? Meaning, why would we care?> > I care because: I find that when I later search for that newly-appended > record with [search db=^dir/mydb.db&eqfield1datarq=123&max=1], then the > [search] will NOT find that record UNTIL / UNLESS I first add a newline > char at the end of the record. I can add that missing newline char > either manually, by directly editing the db, or else I have to [append] > another record so the previous one finally gets its newline char at the > end.> > How'd I do? Clear? Terse? :-)> > -GI'm not aware of any append bugs. I use them all the time, so not sure what to tell you. I would suggest to make sure the .db is solid with allthe usuals, check for non-ASCII and control chars (zap gremlins in bbedit) and make sure the ending carriage return is there.Donovan-- Donovan BrookeWebDNA Software Corporationhttp://www.webdna.us**[Square Bracket Utopia]**
Associated Messages, from the most recent to the oldest:
John Butler wrote:>> John Butler wrote:>>> Version=6.1>>> PLATFORM=unix-Linux Intel RedHat>>> I have a problem that is forcing me to think of creative workarounds >>> for today's code, but more than that is disturbing in general:>>> I have a perfectly normal and working
[append] context.. but it is >>> not ending the record it appends with a newline char. I've seen >>> that before, but just decided to myself that it must be OK (even >>> though a faint voice said it was not supposed to be that way). Once >>> I append another record, then the previous record does get it's >>> delimiting newline char.>>> Well now I am doing a *simple* search on this db, and it finds any >>> specific one record I tell it to find, UNLESS I am trying to find >>> that last record with no newline char at the end. If I manually add >>> the newline char at the end, then the search works as expected.>>> Has anyone had any such experience? Suggestions?>>>> I'm a bit confused at what you are asking.. but>> I would definitely update your "6.1" version to "6.2".>>>> Not sure what release that is that you are using, because we>> didn't officially release a "6.1" version.>>>> Re: your append, maybe post some code?.. and maybe>> a more terse description of what is going on?>>>> Donovan> > This code:> > Version=
[version]> PLATFORM=
[platform]> > returns this:> Version=6.1> PLATFORM=unix-Linux Intel RedHat> > I would LOVE to update the release, but this is on a shared host. I > will put in a request.. but the webdna man there is on honeymoon... so > it won't happen now. Meanwhile I have to produce for the client now.> > ----------------> > this code:> > [Append > db=^dir/mydb.db]field1=123&field2=
[url][val][/url]...&field24=none_yet[/Append] > > > successfully and accurately writes to mydb.db. It writes the new > record which I just asked it to. * BUT * this new record does NOT have > a newline char at the end... UNTIL / UNLESS I
[append] another record.> > So what? Meaning, why would we care?> > I care because: I find that when I later search for that newly-appended > record with [search db=^dir/mydb.db&eqfield1datarq=123&max=1], then the >
[search] will NOT find that record UNTIL / UNLESS I first add a newline > char at the end of the record. I can add that missing newline char > either manually, by directly editing the db, or else I have to
[append] > another record so the previous one finally gets its newline char at the > end.> > How'd I do? Clear? Terse? :-)> > -GI'm not aware of any append bugs. I use them all the time, so not sure what to tell you. I would suggest to make sure the .db is solid with allthe usuals, check for non-ASCII and control chars (zap gremlins in bbedit) and make sure the ending carriage return is there.Donovan-- Donovan BrookeWebDNA Software Corporationhttp://www.webdna.us**[Square Bracket Utopia]**
Donovan Brooke
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:
Re:2nd WebCatalog2 Feature Request (1996)
Problems with [Applescript] (1997)
Web*SSL and WebCatalog (1997)
2 easy questions re: [showif] and [sendmail] (1997)
WC2.0 Memory Requirements (1997)
Drop down menu (2003)
PIXO support (1997)
Re:Emailer tracking (1997)
Looking for PHP programmer (2008)
Prevent multiple appends with Reload Button (1997)
[SHOWIF]s and empty arguments (1997)
ShoppingCart removal (2002)
WebDNA for Dummies (2004)
WebDNA dying or ... ? (2005)
WebTEN vs webSTAR (1998)
unable to launch acgi in WebCat (1997)
Re:no template caching (1997)
Dynamic Exchange Rates (2002)
WebCat2.0 [format thousands .0f] no go (1997)
Trouble with formula.db + more explanation (1997)