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 search the 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 than one--------[/!] [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 the showif --------[/!] [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:

    
  1. Re: search for non-unique question (Brian Fries 2001)
  2. Re: search for non-unique question (Aaron Lynch 2001)
  3. Re: search for non-unique question (Brian Fries 2001)
  4. Re: search for non-unique question (Peter Werno 2001)
  5. Re: search for non-unique question (Dale Therio 2001)
  6. Re: search for non-unique question (Aaron Lynch 2001)
  7. Re: search for non-unique question (Marc@lsaproofing.com 2001)
  8. Re: search for non-unique question (Aaron Lynch 2001)
  9. search for non-unique question (Dale Therio 2001)
This should work, although it is a nasty search as it will have to search the 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 than one--------[/!] [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 the showif --------[/!] [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)