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:
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:
Opinion: [input] should be called [output] ... (1997)
Mac Os X and WebCat (1999)
Search in 2 or more catalogs (1997)
OT: Flash artist needed (2005)
Dynamic Image Generation (2000)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
Emailer port change (1997)
range searching (1998)
NTbeta18 corrupted? (1997)
Re[3]: Charting records by state (2000)
For those of you not on the WebCatalog Beta... (1997)
[sendmail] and [formvariables] (1997)
date (1998)
Email template names (1997)
Cookie Sniffer (2001)
all records returned. (1997)
Migrating to NT (1997)
BannerAds demo (1998)
OK, here goes... (1997)
[WebDNA] test email (2013)