Re: Every other record deleted
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63669
interpreted = N
texte = >So the answer is to delete in reverse order.. > >Works for me after falling into the trap that Brian has just described. The other way is to set the search criteria in your delete tag to match all the records you want to delete at once. There's no need to delete records one-at-a-time inside a FoundItems loop, since the search criteria in the FoundItems loop is the same search criteria you could use for the delete tag itself. Wherever possible, get rid of the outer [Search] and [FoundItems] entirely, and use a single [Delete] to erase records all at once. It's faster, and does not run into this every-other-record thing. -- _______________________________________________________________________________ Grant Hulbert | Internet Software Architect | http://www.hulbertfamily.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:
>So the answer is to delete in reverse order.. > >Works for me after falling into the trap that Brian has just described. The other way is to set the search criteria in your delete tag to match all the records you want to delete at once. There's no need to delete records one-at-a-time inside a FoundItems loop, since the search criteria in the FoundItems loop is the same search criteria you could use for the delete tag itself. Wherever possible, get rid of the outer [search] and [founditems] entirely, and use a single [delete] to erase records all at once. It's faster, and does not run into this every-other-record thing. -- _______________________________________________________________________________ Grant Hulbert | Internet Software Architect | http://www.hulbertfamily.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/
Grant Hulbert
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:
MacAuthorize order data fields WAS:How To question... (1997)
Protect groups and delete command (2000)
New WebCatalog Version !!! (1997)
Fw: [SQL] and [index] mystery solved (2001)
Re:listfiles-looking for slick solution (1997)
[WriteFile] problems (1997)
[WriteFile] problems (1997)
Question on lineitems (2002)
Major Security Hole (1998)
Getting Total Quantity (1997)
Help name our technology! (1997)
Pesky &s (2002)
Help! (2000)
2 easy questions re: [showif] and [sendmail] (1997)
Comments in db? (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
PCS search results page (1998)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Re:no [search] with NT (1997)
[WebDNA] I liked you (2014)