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

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 55109
interpreted = N
texte = can you [delete db=/db/products.db&eqSKUdatarq=1234&max=1]? ----- Original Message ----- From: "Kenneth Grome" To: "WebDNA Talk" Sent: Saturday, December 27, 2003 2:33 PM Subject: Re: how do I delete 1 of 2 identical records? > >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/ > ------------------------------------------------------------- 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)
can you [delete db=/db/products.db&eqSKUdatarq=1234&max=1]? ----- Original Message ----- From: "Kenneth Grome" To: "WebDNA Talk" Sent: Saturday, December 27, 2003 2:33 PM Subject: Re: how do I delete 1 of 2 identical records? > >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/ > ------------------------------------------------------------- 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/ "Andrew Simpson"

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:

[WebDNA] Search using CL (2017) It gets better... posting problems + Webcat 3.0.7 available -did anyone know? (2000) Separate SSL Server (1997) SOP for WebDNA talk - MSNBot Crashing (2004) emailer (1997) getting images' width/height (1998) RE:It just Does't add up!!! (1997) RE: Adding a product from another site (1997) X etc.... (1999) Re1000001: Setting up shop (1997) Applescript error (1998) Why don't my carts expire (1998) Help with Repost Data msg from form (1997) 4.0.x find (2000) shoppingcart reload qty (1997) splitting numbers in webDNA? (1997) convert characters (2003) SpiderBotLock! (2003) Bug when including a db file ... ? (2000) [Webcat 2]Next (1997)