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[2]: 2nd WebCatalog2 Feature Request (1996)
WC2.0 Memory Requirements (1997)
Fun with Dates - finally resolved but.... (1997)
Limit on nested [ShowIf]'s? (1997)
[SearchString] problem with [search] context (1997)
re:Clickable maps and WebCatalog? (1996)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Show Databases in admin (2000)
Quickie question on the email templates (1997)
[include ...] behavior (1997)
IE 6 weirdness ??? (2002)
WebMerchant/MacAuthorize (1998)
send people in a database an email (2001)
Public Beta for WebCatalog 4.0 is Available (2000)
Server Freeze (1998)
X etc.... (1999)
forms (2001)
WebCat2b13MacPlugIn - [include] (1997)
all records returned. (1997)
Subtotal help (1997)