Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.)

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103343
interpreted = N
texte = > 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? :-) -G Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (Kenneth Grome 2009)
  2. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) ("Brian Harrington, Broker" 2009)
  3. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (Kenneth Grome 2009)
  4. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (christophe.billiottet@webdna.us 2009)
  5. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
  6. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (Stuart Tremain 2009)
  7. Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
  8. [WebDNA] [append] does not add the newline char at the end of the new record?! (which causes subsequent [search] to fail.) (John Butler 2009)
> 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? :-) -G John Butler

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:

WebCatalog can't find database (1997) WebStar and CopyFile (2000) [WebDNA] Terminate all threads (2010) New Zealand [OT - was Car Database] (2002) RE: Include (1998) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) WebCatalog/Mac 2.1b2 New Features (1997) Email within tmpl ? (1997) Multiple Pulldowns/Gary (1997) can WC render sites out? (1997) SKU (1997) Draft Manual, Tutorial, and more (1997) about this server and links to who (1997) Sandbox Administation (2003) New Line In grep (2003) Re[2]: Searchable archives gone again??? (2000) Wanted: More Math Functions (or, Can You Solve This?) (1997) [taxrate] question (1997) Error Page? (1997) WebCatalog 4.0.1 has been released! (2000)