Re: Delete only one duplicate record?

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 52474
interpreted = N
texte = On 8/25/03 11:25 AM, "Donovan" wrote: > have you tried using the max=1 peram? > > Donovan > > > Kenneth Grome wrote: >> Does anyone know how to delete only one duplicate record via webdna? I >> know how to do it manually, but I want to do it via webdna. Any >> suggestions? >> I am not sure how this would help. If the record is truly a duplicate (all the fields combined) then you wont be able to simply delete the record as the delete command would have to key on something. If there are any differences in field data beyond the duplicated sku then you can combine them together to perform an exclusive search during the delete... If they are truly duplicated, you could write a quicky that takes your field data, stores them in text vars, deletes the offend record(s) (2 or 20) and then appends the DB with the values of the text vars in a new & unique record. That's about the only way, that I know of, to handle deleting a truly duplicated record in DNA. HTH Alex Alex J McCombie New World Media Chief Information Officer Box 124 888/892.6379 MartVille, NY 13111 Alex@NewWorldMedia.com http://OurClients.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- 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: Delete only one duplicate record? ( Donovan 2003)
  2. Re: Delete only one duplicate record? ( Kenneth Grome 2003)
  3. Re: Delete only one duplicate record? ( Alex McCombie 2003)
  4. Re: Delete only one duplicate record? ( Kenneth Grome 2003)
  5. Re: Delete only one duplicate record? ( Donovan 2003)
  6. Delete only one duplicate record? ( Kenneth Grome 2003)
On 8/25/03 11:25 AM, "Donovan" wrote: > have you tried using the max=1 peram? > > Donovan > > > Kenneth Grome wrote: >> Does anyone know how to delete only one duplicate record via webdna? I >> know how to do it manually, but I want to do it via webdna. Any >> suggestions? >> I am not sure how this would help. If the record is truly a duplicate (all the fields combined) then you wont be able to simply delete the record as the delete command would have to key on something. If there are any differences in field data beyond the duplicated sku then you can combine them together to perform an exclusive search during the delete... If they are truly duplicated, you could write a quicky that takes your field data, stores them in text vars, deletes the offend record(s) (2 or 20) and then appends the DB with the values of the text vars in a new & unique record. That's about the only way, that I know of, to handle deleting a truly duplicated record in DNA. HTH Alex Alex J McCombie New World Media Chief Information Officer Box 124 888/892.6379 MartVille, NY 13111 Alex@NewWorldMedia.com http://OurClients.com Interface Designer WebDNA Programmer Database Designer ------------------------------------------------------------- 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/ Alex McCombie

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:

protect tag on NT IIS (1997) [WebDNA] Feature Request: [returnhtml] (2016) Identical [Replace] contexts, different results in different directories? (2000) possible, WebCat2.0 and checkboxes-restated (1997) Emails are Stuck (2003) feature request-- [epoch] (2004) [WebDNA] Cheers (2008) security (1997) show if date < expiry date (2002) still having shipCost.db Problem (1997) Generating Report Totals (1997) Text limits in NT version? (1997) Database Updates (1997) [Sum] function? (1997) newbie question about zip code search (2003) WebCat2 beta 11 - new prefs ... (1997) [SearchString] (1998) Plugin or CGI or both (1997) Major problem (1999) Looking for a Manual (1997)