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:

    
  1. Re: Every other record deleted ( Donovan Brooke 2005)
  2. Re: Every other record deleted ( Peter Ostry 2005)
  3. Re: Every other record deleted ( Grant Hulbert 2005)
  4. Re: Every other record deleted ( Stuart Tremain 2005)
  5. Re: Every other record deleted ( Brian Fries 2005)
  6. Re: Every other record deleted ( Jesse Proudman 2005)
  7. Re: Every other record deleted ( Jesse Proudman 2005)
  8. Re: Every other record deleted ( "Dan Strong" 2005)
  9. Re: Every other record deleted ( Donovan Brooke 2005)
  10. Re: Every other record deleted ( "Dan Strong" 2005)
  11. Re: Every other record deleted ( Donovan Brooke 2005)
  12. Re: Every other record deleted ( "Dan Strong" 2005)
  13. Re: Every other record deleted ( "Eric Miller" 2005)
  14. Every other record deleted ( "Dan Strong" 2005)
>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:

reverse of math value... (2004) WebCatalog for Postcards ? (1997) Almost a there but..bye bye NetCloak (1997) [OT] Airport Problem (2003) RE: protect tag on NT (1997) How to display images? (2002) RE: ShowNext Command (1997) WebCat2.0 acgi vs plugin (1997) Initiating NewCart (1997) Getting Total Quantity (1997) no global [username] or [password] displayed ... (1997) Multiple prices (1997) sorting and grouping (1998) Disappearing data (2002) CART question (2004) emailer on Windows Beta 18 (1997) Storing dates (was: Ticket Ordering Question) (2003) allow or deny based on referer.... (1997) WebCommerce: Folder organization ? (1997) Using Cookie for client specific info? (1997)