Re: Duplicates
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17745
interpreted = N
texte = >For the 2 of you who haven't added me to your kill file... >Does anyone have a good way for detecting records that have a duplicate >value in one field, then noting this, or deleting it?I think you'd have to create a temporary database that stores each word from that field in a separate record, then search that temp db for all the records with the duplicate word you're looking for, then replace the value of that word with a blank value, then search and retrieve all the records of this temp db file and put the results back into the field of the original db record replacing the original field values.Of course, this assumes that you're seeking a specific word and not just any duplicates, because I'm not sure there's a good way of doing this if your goal is to seek out ANY duplicate words. So maybe it's going to be easier to prevent the duplicates from being entered in the first place.What's the purpose of this effort? Are you trying to create a keyword field that doesn't have duplicate values in it? Or is this for some other purpose entirely?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>For the 2 of you who haven't added me to your kill file... >Does anyone have a good way for detecting records that have a duplicate >value in one field, then noting this, or deleting it?I think you'd have to create a temporary database that stores each word from that field in a separate record, then search that temp db for all the records with the duplicate word you're looking for, then replace the value of that word with a blank value, then search and retrieve all the records of this temp db file and put the results back into the field of the original db record replacing the original field values.Of course, this assumes that you're seeking a specific word and not just any duplicates, because I'm not sure there's a good way of doing this if your goal is to seek out ANY duplicate words. So maybe it's going to be easier to prevent the duplicates from being entered in the first place.What's the purpose of this effort? Are you trying to create a keyword field that doesn't have duplicate values in it? Or is this for some other purpose entirely?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
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:
Sorting error (1997)
shownext not showing next...still r2 (1997)
[WebDNA] WebDNA staging server (2008)
Timer Values on [redirect] (1998)
F2 to F3 rocky transition (1997)
QuitFeedback & DBNotOpened errors (1997)
Date Calulation (1997)
ShowIf variables (1997)
WebCat for Unix?? (1997)
Appending current [date] to a database (1997)
Logging purchases (1997)
Security stumper [mildly OT] (2004)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Make sure I understand this??? (1997)
b12 cannot limit records returned and more. (1997)
Include vs. lookup? (1998)
[WebDNA] Now: Listfields does not work with tables - Was: [OT] MySQL Users (2011)
Credit Card Number checking (1997)
Ship Cost Calculated via Subtotal (1998)
Multiple prices (1997)