Re: Every other record deleted
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63670
interpreted = N
texte = On 23.12.2005, at 02:38, Brian Fries wrote: > The typical cause of an every-other deletion is doing a deletion > inside a founditems loop. As soon as you delete a record, the > indexes of the founditems set have been changed... > ...[snip]... > This is considered a "behavior" of WebDNA rather than a "bug". It is neither a special behavior nor a bug. It is the "logical" behavior of all database applications when you work directly on records. I see that like removing parts of the floor you are standing on. Deleting in a reversed order is a trick but, well, not a clean technique if I am allowed to say that. We have to collect the records in question in a sort of array, db file or somewhere else and do the deletion afterwards. Or, as mentioned by Grant, use the [Delete...] function if the type of query allows it. ___ Peter Ostry ------------------------------------------------------------- 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:
On 23.12.2005, at 02:38, Brian Fries wrote: > The typical cause of an every-other deletion is doing a deletion > inside a founditems loop. As soon as you delete a record, the > indexes of the founditems set have been changed... > ...[snip]... > This is considered a "behavior" of WebDNA rather than a "bug". It is neither a special behavior nor a bug. It is the "logical" behavior of all database applications when you work directly on records. I see that like removing parts of the floor you are standing on. Deleting in a reversed order is a trick but, well, not a clean technique if I am allowed to say that. We have to collect the records in question in a sort of array, db file or somewhere else and do the deletion afterwards. Or, as mentioned by Grant, use the [Delete...] function if the type of query allows it. ___ Peter Ostry ------------------------------------------------------------- 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/
Peter Ostry
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:
WebCatalog2 Feature Feedback (1996)
What really killed WebDNA? (2007)
FM fields with CR - How to export/import? (2000)
webcat 2.1 (1997)
MacOS X 10.1 Upgrade Error (2001)
Possible Shownext from Listfiles???? (2000)
Multiple security dbs (1997)
Anyone get webdna to run on apache 2.x on osx? (2006)
CommandSecurity? (1997)
'does not contain' operator needed ... (1997)
[include] affect on filepaths for links? (1997)
Calculating multiple shipping... (1997)
Group search doesn't work. (1997)
HELP WITH DATES (1997)
How do I find where my IP address is located (2000)
The Box - (2002)
Recycling fee (1998)
t or f (1997)
[SearchString] problem with [search] context (1997)
PCS Frames (1997)