search for non-unique question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40280
interpreted = N
texte = WebCatalog 3.0.7 on Mac OSHello,I have a database with about 10,000 records in it. I need to do a search on a specific field (nickname) and find all records that have more than one match.What I am doing is trying to take an existing field and eventually make the value in that field a unique value, so in order to do that I need to find all records where there is a conflict and notify those users that they will need to change their nickname.Got any ideas on how to construct such a search?Oh, and many of the records currently have this field blank, I will deal with those users as a seperate case.Thanks for any suggestions.Dale-------------------------------------------------------------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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
WebCatalog 3.0.7 on Mac OSHello,I have a database with about 10,000 records in it. I need to do a search on a specific field (nickname) and find all records that have more than one match.What I am doing is trying to take an existing field and eventually make the value in that field a unique value, so in order to do that I need to find all records where there is a conflict and notify those users that they will need to change their nickname.Got any ideas on how to construct such a search?Oh, and many of the records currently have this field blank, I will deal with those users as a seperate case.Thanks for any suggestions.Dale-------------------------------------------------------------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://search.smithmicro.com/
Dale Therio
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:
double lines in sendmail (2008)
Date search and sendmail (1997)
4.5 Upgrade (2003)
Format date.... (2003)
Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
LetterRip and WebCat (1998)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
XML documentation online? was RE: Help with (2003)
WebCat2b15MacPlugin - [protect] (1997)
Deleting Orders (1997)
Tracking (2004)
Dark Horse Comics success story (1997)
filemaker - orderfile (1997)
Nested tags count question (1997)
PCS Emailer's role ? (1997)
I give up!! (1997)
RAM variables (1997)
[append] and SSL (1997)
database size? (1997)
_ in front of field name (1998)