Re: Database wiped clean
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61170
interpreted = N
texte = I found what may be the source of this deadly behavior. It has to do with [delete] inside a found items loop. It's rather nasty and not easily found by just looking at the code. That is, it isn't due to poor WebDNA coding. This may have been fixed in recent versions. When WebCatalog reads in a database it indexes the records based on the physical order that they appeared in the data file. When you do a search the list of returned items, at it's core, is a list of these indexes. If you did a delete on an index that came before a record returned later in the found items (because of sorting), then the indexes in the found items would be off and subsequent deletes wouldn't delete the expected records. I know this isn't the most easily understood explanation. Like I said, this is definitely an issue in older versions (I think 4 or so), and may have been fixed in the more recent ones. I believe very old versions, however, may work OK. >David Cate wrote: > >> How would you recommend one to search for a delete context in a bunch of text files? Just curious because this is a recurring problem on our side too.... >> Any advice appreciated. > >The best tool kinda depends on your platform. *nix has a lot of >good tools for this but someone else will have to tell you the commands. >What platform are you running? > >Donovan > > > > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Eucalyptus Design > <-Web Development (specializing in eCommerce), -> > <- Graphic Design, Custom Tags and Labels -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > N2862 Summerville Park Rd. > Lodi, WI 53555 > PH:> 1.608.592.3567 > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list
. >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I found what may be the source of this deadly behavior. It has to do with [delete] inside a found items loop. It's rather nasty and not easily found by just looking at the code. That is, it isn't due to poor WebDNA coding. This may have been fixed in recent versions. When WebCatalog reads in a database it indexes the records based on the physical order that they appeared in the data file. When you do a search the list of returned items, at it's core, is a list of these indexes. If you did a delete on an index that came before a record returned later in the found items (because of sorting), then the indexes in the found items would be off and subsequent deletes wouldn't delete the expected records. I know this isn't the most easily understood explanation. Like I said, this is definitely an issue in older versions (I think 4 or so), and may have been fixed in the more recent ones. I believe very old versions, however, may work OK. >David Cate wrote: > >> How would you recommend one to search for a delete context in a bunch of text files? Just curious because this is a recurring problem on our side too.... >> Any advice appreciated. > >The best tool kinda depends on your platform. *nix has a lot of >good tools for this but someone else will have to tell you the commands. >What platform are you running? > >Donovan > > > > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Eucalyptus Design > <-Web Development (specializing in eCommerce), -> > <- Graphic Design, Custom Tags and Labels -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > N2862 Summerville Park Rd. > Lodi, WI 53555 > PH:> 1.608.592.3567 > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ -- --------------------------------- John A. Hill Oak Hill Software Website Development/Consulting john@oakhillsoftware.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
John Hill
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:
More questions about serial number dishing (1997)
Security Hole - NetCloak Update (1998)
Removing username from browser (2000)
Re:Emailer tracking (1997)
vs (1997)
PCS Emailer's role ? (1997)
(2003)
input type=file has no value? (2003)
oops private message leaked into talk list (1997)
no time stamp & different times from emailer (1998)
RE: Questions To Answer (1997)
Re: (1998)
[WebDNA] Advices for Linux Config (2017)
Search as error page (2002)
Keeping text formatting (like hard returns) (2002)
RE: ShowNext Command (1997)
WebMerchant and MacAuthorize Errors (1998)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Digest for 4/18/97 (1997)
Security (1998)