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:
Hiding HTML and page breaks (1997)
RAM variables (1997)
[carts] and databases (1997)
WebCat2 - [include] tags (1997)
problems with 2 tags shakur (1997)
Snake Bites (1997)
[math] are you there? (1999)
Reversed words (1997)
Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997)
[WebDNA] new install - documentation (2017)
[format 40s]text[/format] doesn't work (1997)
[CONVERTCHARS] suggestion (2000)
WebCatalog/Mac 2.1b2 New Features (1997)
plugin-acgi, different results (1997)
WC2f3 (1997)
[WebDNA] PHP and WebDNA together? (2011)
MacAuthorize order data fields WAS:How To question... (1997)
Re1000001: Setting up shop (1997)
New Webcatalog for Mac (1997)
[WebDNA] Anyone submitted SoAP info in TCPSEND? (2017)