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

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55107
interpreted = N
texte = Hi Dale, I had this happen once on a more widespread scale. Wasn't pretty. I asked the same question and was provided with some sample code. This was some time ago, so sorry that I can't credit the author, but it went something like this: [search and find all records...] [text]prevrecord=nadamatch[/text] [founditems] [showif [url][sku][/url]=[prevrecord]] A duplicate was detected for the SKU: [sku]
[!]--delete or do you what you need to here --[/!] [/showif] [text]prevrecord=[url][sku][/url][/text] [/founditems] [/search] GK At 06:33 PM 12/26/2003, you wrote: >Hi, > >I have a database that at one point had some poor add record code. As a >result, one record has been duplicated exactly. Any time this record is >updated both records are updated. I need to delete 1 of these records, but >so far my test attempts have resulted in deleting both (using a test >database of course). > >Does anyone have an idea what to do to delete only 1 of 2 identical >records? I tried using &max=1 in replace, but that doesn't seem to have an >effect. > >WebCat 4.5.1 on Linux > >Thanks > >Dale ------------------------------------------------------------- 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)
Hi Dale, I had this happen once on a more widespread scale. Wasn't pretty. I asked the same question and was provided with some sample code. This was some time ago, so sorry that I can't credit the author, but it went something like this: [search and find all records...] [text]prevrecord=nadamatch[/text] [founditems] [showif [url][sku][/url]=[prevrecord]] A duplicate was detected for the SKU: [sku]
[!]--delete or do you what you need to here --[/!] [/showif] [text]prevrecord=[url][sku][/url][/text] [/founditems] [/search] GK At 06:33 PM 12/26/2003, you wrote: >Hi, > >I have a database that at one point had some poor add record code. As a >result, one record has been duplicated exactly. Any time this record is >updated both records are updated. I need to delete 1 of these records, but >so far my test attempts have resulted in deleting both (using a test >database of course). > >Does anyone have an idea what to do to delete only 1 of 2 identical >records? I tried using &max=1 in replace, but that doesn't seem to have an >effect. > >WebCat 4.5.1 on Linux > >Thanks > >Dale ------------------------------------------------------------- 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/ Gary Krockover

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:

denied access (1997) Interactive Docs (2007) Sort Order on a page search (1997) permission deny help please (2004) [BULK] [WebDNA] Multiple e-mail sending (2011) Search in 2 or more catalogs (1997) PCS Frames (1997) [WebDNA] File Include HTM (2008) [random] only for 1-100??? (1997) [sendmail] questions... (1997) Cookie still not working (1999) transferring password & username (2000) Size limit for tmpl editor ? (1997) WebDNA to IM connectivity? (2006) [Webcat 2]Next (1997) [WebDNA] [OT] ImageMagick or similar (2015) catagories (1997) Close-to Comparison Code (1998) tcpconnect (1999) HELP WITH DATES (1997)