Re: search for non-unique question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40284
interpreted = N
texte = This should work, although it is a nasty search as it will have to searchthe db 10,000 times less the blanks:[!]---------Search for all nicknames--------[/!][Search db=your_users.db&nenicknamedata=findall&nenicknamedata=[blank]][founditems][!]---------Then take each nickname to research for numfound greater thanone--------[/!][Search db=your_users.db&eqnicknamedata=[nickname]&nicknamesort=1&nicknamesdir=as][showif [numfound]>1][founditems][!]---------If more than one nickname is found it will display within theshowif --------[/!][nickname]
[/founditems][/showif][/search][/founditems][/search]On 11/24/01 3:54 AM, 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> > > -------------------------------------------------------------> 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/-------------------------------------------------------------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:
This should work, although it is a nasty search as it will have to searchthe db 10,000 times less the blanks:[!]---------Search for all nicknames--------[/!][Search db=your_users.db&nenicknamedata=findall&nenicknamedata=[blank]][founditems][!]---------Then take each nickname to research for numfound greater thanone--------[/!][Search db=your_users.db&eqnicknamedata=[nickname]&nicknamesort=1&nicknamesdir=as][showif [numfound]>1][founditems][!]---------If more than one nickname is found it will display within theshowif --------[/!][nickname]
[/founditems][/showif][/search][/founditems][/search]On 11/24/01 3:54 AM, 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> > > -------------------------------------------------------------> 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/-------------------------------------------------------------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/
Marc@lsaproofing.com
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:
sku not found (1997)
suffix mapping, use of cache, etc. (1997)
[SubTotal] ??? (1998)
Webstar 1.3.1 PPC (1997)
archives down (2001)
Queertrons? (1997)
Shared conversion under WebTen (1998)
Robert Minor duplicate mail (1997)
[CART] inside a [LOOP] (1997)
[SHOWIF AND/OR] (1997)
Formating found categories (1997)
Web Catalog 2 demo (1997)
RE: WebCat and image maps (1997)
Making webcam movies (2003)
Dealer Locator (2008)
javascript newPopwin and webcat (1998)
Generating Report Totals (1997)
WebCatalog2 Feature Feedback (1996)
WebCatalog-NT?'s (1996)
Problems getting parameters passed into email. (1997)