Re: how do I delete 1 of 2 identical records?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55112
interpreted = N
texte = But you could SEARCH with max=1, use REPLACEFOUNDITEMS to modify the one found record, then DELETE the modified record. Or, if you may have multiple duplicate records, you could SEARCH with startat=2, leaving the first record alone and modifying then deleting all the duplicates. - brian On Dec 26, 2003, at 6:51 PM, Kenneth Grome wrote: >> can you [delete db=/db/products.db&eqSKUdatarq=1234&max=1]? > > No, max=1 does not work in replace or delete contexts. The max > parameter is used to ONLY to control the number of found items > displayed inside a founditems context. It is ignored in replace and > delete contexts. > -- > > Kenneth Grome > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  2. Re: how do I delete 1 of 2 identical records? ( Brian Fries 2003)
  3. Re: how do I delete 1 of 2 identical records? ( Grant Hulbert 2003)
  4. Re: how do I delete 1 of 2 identical records? ( "Andrew Simpson" 2003)
  5. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  6. Re: how do I delete 1 of 2 identical records? ( Brian Fries 2003)
  7. Re: how do I delete 1 of 2 identical records? ( "Matthew Bohne" 2003)
  8. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  9. Re: how do I delete 1 of 2 identical records? ( "Andrew Simpson" 2003)
  10. Re: how do I delete 1 of 2 identical records? ( Kenneth Grome 2003)
  11. Re: how do I delete 1 of 2 identical records? ( Gary Krockover 2003)
  12. how do I delete 1 of 2 identical records? ( CN Stuff 2003)
But you could SEARCH with max=1, use REPLACEFOUNDITEMS to modify the one found record, then DELETE the modified record. Or, if you may have multiple duplicate records, you could SEARCH with startat=2, leaving the first record alone and modifying then deleting all the duplicates. - brian On Dec 26, 2003, at 6:51 PM, Kenneth Grome wrote: >> can you [delete db=/db/products.db&eqSKUdatarq=1234&max=1]? > > No, max=1 does not work in replace or delete contexts. The max > parameter is used to ONLY to control the number of found items > displayed inside a founditems context. It is ignored in replace and > delete contexts. > -- > > Kenneth Grome > -- Brian Fries, BrainScan Software -- http://www.brainscansoftware.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/ Brian Fries

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:

[append] (1997) Shownext never shows next...still (1997) Converting SQL Microtime to Date and Time (2003) Problems with [Applescript] (1997) Unable to view next 101-200 (1997) Nested search (1997) [ot] ShowIf & HideIf Question (1998) Forumulas.db & Variables (2002) RE: Cart Template (1997) WC2b15 File Corruption (1997) ServerQuestion (2000) oops private message leaked into talk list (1997) Tip for making barcharts (1997) random images (1997) Field names beginning with Reg.. (2002) generating a space delimited file (2001) cookies and [returnraw] (1997) SiteGuard Admin Feature ? (1997) Download URL & access on the fly ? (1997) WebTen and WebCat (1997)