Re: Duplicates
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17772
interpreted = N
texte = >>>>Does anyone have a good way for detecting records that have a duplicate>>>>value in one field, then noting this, or deleting it?>>>>>>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?>>>>Sorry, I should have been more specific with my request.>>I have a database with 4 fields. ID, Email, adddate, promostatus..>>To be even more specific, is there *ever* more than one email address in >the Email field?There was, but I killed them all by hand. I still keep an eye out for andor ; in this field, and go in a clean it when I find this. This whole taskwould be easier if we had some sort of string variables...Anyway, I guessI'm still looking for the best possible solution, because my next task willbe to take similar code and clean up and maintain user/catalog requestdatabases for several other sites I have. Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com
Associated Messages, from the most recent to the oldest:
>>>>Does anyone have a good way for detecting records that have a duplicate>>>>value in one field, then noting this, or deleting it?>>>>>>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?>>>>Sorry, I should have been more specific with my request.>>I have a database with 4 fields. ID, Email, adddate, promostatus..>>To be even more specific, is there *ever* more than one email address in >the Email field?There was, but I killed them all by hand. I still keep an eye out for andor ; in this field, and go in a clean it when I find this. This whole taskwould be easier if we had some sort of string variables...Anyway, I guessI'm still looking for the best possible solution, because my next task willbe to take similar code and clean up and maintain user/catalog requestdatabases for several other sites I have. Brian B. Burton BOFH - Department of Redundancy Department--------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com
Brian B. Burton
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:
Webmerchant confirmation hooks? (1997)
WebCat NT v. Mac (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
NTbeta18 corrupted? (1997)
Still ignoring the 3.x bugs? (2000)
[WebDNA] New Licenses (2009)
[cart] number range ?? (2001)
A little syntax help (1997)
removelineitems (2000)
searching multiple databases (1997)
Trouble with formula.db (1997)
[WebDNA] OSX Yosemite (2014)
Installing on IIS 5.1 Windows XP Pro - Username/Password (2006)
Pass a form (2003)
WebCat2b15MacPlugin - [protect] (1997)
Meet your competition (2000)
WebCatalog Plug-in for Webstar. (1997)
Templetes? (1999)
[date] insanity! (2001)
Getting total number of items ordered (1997)