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

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55108
interpreted = N
texte = >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). All you have to do is create a way to distinguish between the two records, then delete only one of them. Here's a simple solution that adds a new field to the db so you can use it to distinguish one record from another uniquely. Then it deletes one of the two (or three or four or more) previously identical records. This code will delete all but one record in each set of duplicate (triplicate, quadruplicate, etc.) records in the db, not just the first one it finds. It is a one-step solution. The only two things it requires is that you use a field named "sku" that is supposed to have a unique value in it for each record, and that you also use a ..hdr file for the db you're trying to fix: [text]deleteList=[/text] [text]mostOfTheDbHeaderFile=[getchars start=2&from=end][include xxx.hdr][/getchars][/text] [closedatabase xxx.db] [writefile xxx.hdr][mostOfTheDbHeaderFile]newField [/writefile] [search db=xxx.db&neskudatarq=[blank]&asskusort=1] [replacefounditems][newField]=[index][/replacefounditems] [founditems] [showif [lastSKU]=[sku]] [text]deleteList=[deleteList],[newField][/text] [/showif] [text]lastSKU=[sku][/text] [/founditems] [/search] [delete db=xxx/db&wonewFielddatarq=[deleteList]&newFieldword=ww] -- Kenneth Grome ------------------------------------------------------------- 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)
>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). All you have to do is create a way to distinguish between the two records, then delete only one of them. Here's a simple solution that adds a new field to the db so you can use it to distinguish one record from another uniquely. Then it deletes one of the two (or three or four or more) previously identical records. This code will delete all but one record in each set of duplicate (triplicate, quadruplicate, etc.) records in the db, not just the first one it finds. It is a one-step solution. The only two things it requires is that you use a field named "sku" that is supposed to have a unique value in it for each record, and that you also use a ..hdr file for the db you're trying to fix: [text]deleteList=[/text] [text]mostOfTheDbHeaderFile=[getchars start=2&from=end][include xxx.hdr][/getchars][/text] [closedatabase xxx.db] [writefile xxx.hdr][mostOfTheDbHeaderFile]newField [/writefile] [search db=xxx.db&neskudatarq=[blank]&asskusort=1] [replacefounditems][newField]=[index][/replacefounditems] [founditems] [showif [lastSKU]=[sku]] [text]deleteList=[deleteList],[newField][/text] [/showif] [text]lastSKU=[sku][/text] [/founditems] [/search] [delete db=xxx/db&wonewFielddatarq=[deleteList]&newFieldword=ww] -- Kenneth Grome ------------------------------------------------------------- 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/ Kenneth Grome

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:

writing orders to a db (1997) insert graphic in email (2000) Email within tmpl ? (1997) replacing items in a db (2000) WebCat2 beta 11 - new prefs ... (1997) Extended [ConvertChars] (1997) Add to Cart & List of Products (1997) removing commas from a preformatted number (2000) problems with 2 tags (1997) Question about replacing words (1998) where to put code (1998) Download URL & access on the fly ? (1997) Need help... (1997) WebCommerce: Folder organization ? (1997) retain raw [cart] submitted value (2004) Missing Cart Information (2003) WebDNA Docs - interactive - beta (2003) SSL and reg web* (1997) [WebDNA] Help with work-around format date (2013) emailer (1997)