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 = 103344
interpreted = N
texte = You could add in an extra append until it gets fixed and then do a clean up after ..... Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 20/08/2009, at 10:57 AM, 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? :-) > > -G > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 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)
You could add in an extra append until it gets fixed and then do a clean up after ..... Regards Stuart Tremain IDFK Web Developments AUSTRALIA webdna@idfk.com.au On 20/08/2009, at 10:57 AM, 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? :-) > > -G > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Bug Reporting: http://forum.webdna.us/eucabb.html?page=topics&category=288 Stuart Tremain

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:

using showpage and showcart commands (1996) How to best sort in a pre-defined item-by-item order ... (2003) IE Cache Problems... (1999) Showif for mulitple variations (1997) Emailer choke (1997) Generating Report Totals (1997) Does anyone have a solution to make carts smaller? (1998) Resume Catalog ? (1997) switching users (1998) default value from Lookup (was Grant, please help me) (1997) Authorize.net? (2003) Multiple prices per product (2004) Almost a there but..bye bye NetCloak (1997) Newbie from and old bee (1997) SQL (2003) Shipping Calculation Problem (1997) Help name our technology! (1997) Is this possible in simple search? question? (1998) taxTotal, grandTotal (1997) Lookup Notfound (1998)