[RESOLVED, I THINK] -- Re: [WebDNA] [append] does not add the newline char at the end of the new record?! (which can causes subsequent [search] to fail.)
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 103363
interpreted = N
texte = I appreciate everyone's responses.. the little bits of awareness that each contributed led me (I think) to what I was doing wrong.(And I tried to maintain that attitude that is was me, as I probed, to suss out exactly what was the issue, ...plus as Chris said we should all have been having real problems for a long time if [append] was not working properly.I am not sure, but I think the issue does seem to have something to do with the way CR/LF are displaying in Fetch/BBedit.Here is what I was doing:1) [append] a record.2) I flush all db's so I know the ram copy is on the disk.3) decide I am done with that (test) record, so I open the mydb.db file directly from within Fetch (mac ftp client) which causes it to actually open in BBedit.4) I select that last record, and hit the delete key.. then command-S (saves it back on the remote host), command-W closes the file on my end, and I thought all was well.5) then I do a [search] for the record which is now the current last record in that db. WebDNA does not find it... when I know it should6) I open the db file again with fetch/Bbedit and see there is no newline char at the end of the last record.7) confirm the phenom, .. sweat, ... complain to list..Now what I think I discovered is that:-the only time the [search] fails is when I search for the record which is immediately above the record I just deleted *manually* (as per the above description).-It seems like somehow that last CR/LF char is just not displaying when I open the db file remotely (as per the above description).. and then when I save it back to disk it actually does lose the char.I am not sure about anything here.. but now I can only reproduce the problem if I do as I describe above, so for now i am just not doing that ;-)-G
Associated Messages, from the most recent to the oldest:
I appreciate everyone's responses.. the little bits of awareness that each contributed led me (I think) to what I was doing wrong.(And I tried to maintain that attitude that is was me, as I probed, to suss out exactly what was the issue, ...plus as Chris said we should all have been having real problems for a long time if
[append] was not working properly.I am not sure, but I think the issue does seem to have something to do with the way CR/LF are displaying in Fetch/BBedit.Here is what I was doing:1)
[append] a record.2) I flush all db's so I know the ram copy is on the disk.3) decide I am done with that (test) record, so I open the mydb.db file directly from within Fetch (mac ftp client) which causes it to actually open in BBedit.4) I select that last record, and hit the delete key.. then command-S (saves it back on the remote host), command-W closes the file on my end, and I thought all was well.5) then I do a
[search] for the record which is now the current last record in that db. WebDNA does not find it... when I know it should6) I open the db file again with fetch/Bbedit and see there is no newline char at the end of the last record.7) confirm the phenom, .. sweat, ... complain to list..Now what I think I discovered is that:-the only time the
[search] fails is when I search for the record which is immediately above the record I just deleted *manually* (as per the above description).-It seems like somehow that last CR/LF char is just not displaying when I open the db file remotely (as per the above description).. and then when I save it back to disk it actually does lose the char.I am not sure about anything here.. but now I can only reproduce the problem if I do as I describe above, so for now i am just not doing that ;-)-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:
Professional WebDNA Hosting Solutions (2005)
carriage returns in data (1997)
WebDNA Solutions ... sorry! (1997)
Need help with emailer- 2 issues (1997)
Pithy questions on webcommerce & siteedit (1997)
Country & Ship-to address & other fields ? (1997)
Site Test Please [OT] (2005)
[WebDNA] Code Library (2013)
[BULK] [WebDNA] port from mime headers? (2017)
[WebDNA] CICADA (2009)
[group] ? (1997)
SendMail - Idea (2000)
StandardConversions.db (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
Summing fields (1997)
Nested tags count question (1997)
Menu to select product variations (1997)
WebCat2.0 [format thousands .0f] no go (1997)
[WebDNA] two ideas for running a cluster of WebDNA servers (2019)
[ShowIf] and empty fields (1997)