Re: search for non-unique question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40304
interpreted = N
texte = Faster than doing 10,000 searches:[text]lastNickName=[/text] [search db=database.db&neNickNamedata=[blank]&allhit=1&asNickNamesort=1][founditems] [showif [url][NickName][/url]=[url][lastNickName][/url]] ** [NickName] ** is duplicated [/showif] [text]lastNickName=[NickName][/text] [/founditems][/search]- brianAt 11:54 AM +0000 11/24/2001, Dale Therio wrote: >WebCatalog 3.0.7 on Mac OS > >Hello, > >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 > -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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:
Faster than doing 10,000 searches:[text]lastNickName=[/text] [search db=database.db&neNickNamedata=[blank]&allhit=1&asNickNamesort=1][founditems] [showif [url][NickName][/url]=[url][lastNickName][/url]] ** [NickName] ** is duplicated [/showif] [text]lastNickName=[NickName][/text] [/founditems][/search]- brianAt 11:54 AM +0000 11/24/2001, Dale Therio wrote: >WebCatalog 3.0.7 on Mac OS > >Hello, > >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 > -- <= Brian C. Fries, BrainScan Software http://www.brainscansoftware.com =>------------------------------------------------------------- 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/
Brian Fries
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:
WebDNA for Dummies (2003)
Shownext from POST (2000)
WC2b15 File Corruption (1997)
See [shell]s (2008)
WebCatalog NT beta 18 problem (1997)
Great product and great job ! (1997)
WebCat2: Found Items syntax, etc. (1997)
[protect admin] (1997)
Problems getting parameters passed into email. (1996)
Try not to laugh (2007)
WebCat2 - many [carts] on one template page? (1997)
Quit revisited (1997)
Documentation Feedback (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
[OT] XML Primer (2004)
[middle] (2000)
Frames and WebCat (1997)
[ReturnRaw] and hiding FORM data (2003)
SMTP Mail Server (2003)
Version 4? (2000)