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:

docs for WebCatalog2 (1997) Initiating NewCart (1997) Mem per threads (1998) RAM variables (1997) Signal Raised Error (Part III) (1997) Only charge card when product shipped ? (1997) A simple email page? (1999) Web Developer Product Awards (1997) Corruption in images (2004) turning every 5th line red (1999) Hiding Brands (2004) WebCatalog stalls (1998) Re1000001: Setting up shop (1997) PCS Frames (1997) Web DNA... (2007) Database monitoring (2005) Bug Report, maybe (1997) [WebDNA] Help me install (WebDNA 7 fastcgi install on Lion 10.7.3) (2012) problems with WebCat-Plugin (1997) WebCat2b12 CGI Mac - [shownext] problem (1997)