Re: search for non-unique question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40281
interpreted = N
texte = I don't quite understand what you want to do.You want to find records whose nickname is also in some other record's nickname field? Or you want to find all records whose nickname has more than one match to somename If it's the former try something like this:[search db=db&nenicknamedata=0][founditems] [nickname] occurs in [search db=db&eqnicknamedata=[nickname]&nicknameword=ww][founditems][sku],[/foundite ms][/search] [/founditems] [/search]On 11/24/01 3:54 AM, Dale Therio mashed the following keys :> 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)
I don't quite understand what you want to do.You want to find records whose nickname is also in some other record's nickname field? Or you want to find all records whose nickname has more than one match to somename If it's the former try something like this:[search db=db&nenicknamedata=0][founditems] [nickname] occurs in [search db=db&eqnicknamedata=[nickname]&nicknameword=ww][founditems][sku],[/foundite ms][/search] [/founditems] [/search]On 11/24/01 3:54 AM, Dale Therio mashed the following keys :> 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/ Aaron Lynch

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:

Alternating colors (1997) WebCatalog/Mac 2.1b2 New Features (1997) Bulk Linebreak Changes (2002) WC Database Format (1997) [subtotal] problems -- help? (1998) Search a date field specificly the month only... (1999) WebDNA for Dummies (2004) japanese characters (1997) X etc.... (1999) learning PHP (2007) WebCat2 beta 11 - new prefs ... (1997) More DateMath problems (1997) summ=T (2003) PIXO support (1997) bug ? causes NT event log to fill (1997) WebCat2.0 [format thousands .0f] no go (1997) Search all Fields in a db (1997) Replace context problem ... (1997) [movefile] create stationery files (1998) Where is f2? (1997)