Re: search for non-unique question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40286
interpreted = N
texte = Hi Aaron,Sorry for the confusion. I have a site where users enter their name then optionally a nickname. The nickname has never needed to be unique, however with upcoming changes, the nickname does need to be unique. So as a first step I need to find out where I have duplicate nicknames so I can notify the users and work something out to change the nickname.So I only need to find out where there are duplicate entries in this particular field.If someone has joebear as their nickname and there are no other nickname entries with this value then his record id fine. Of course the next step is to make sure no one enters a new record with an existing nickname :) Oh the fun of new features!ThanksDaleOn Sat, 24 Nov 2001 06:59:46 -0800 Aaron Lynch wrote: >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/ ------------------------------------------------------------- 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)
Hi Aaron,Sorry for the confusion. I have a site where users enter their name then optionally a nickname. The nickname has never needed to be unique, however with upcoming changes, the nickname does need to be unique. So as a first step I need to find out where I have duplicate nicknames so I can notify the users and work something out to change the nickname.So I only need to find out where there are duplicate entries in this particular field.If someone has joebear as their nickname and there are no other nickname entries with this value then his record id fine. Of course the next step is to make sure no one enters a new record with an existing nickname :) Oh the fun of new features!ThanksDaleOn Sat, 24 Nov 2001 06:59:46 -0800 Aaron Lynch wrote: >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/ ------------------------------------------------------------- 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:

Physical Security for WebCatalog Directories (1997) Copyright ? (1997) Serving images from databases (1998) 2.0 Info (1997) Security for malls with different webmasters (1998) Prevent multiple appends with Reload Button (1997) Subject: Authenticating users without dialog box (1997) [isfile] ? (1997) Changing price for a SLU based on options (size, etc.) (1997) Help :( (2001) File Uploads... (1997) Error log crashes server? (1999) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Robust WebDNA Job Manager / Accountant (2006) shipCost (1998) Missing Cart Information (2003) WebDNA Solutions ... sorry! (1997) Progress !! WAS: Trouble with formula.db (1997) [defined]ish (1997) Problems with date math (1997)