Re: search for non-unique question
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 40285
interpreted = N
texte = On a db with 10k records, wouldn't this be 20k searches? :) On 11/24/01 8:59 PM, Marc@lsaproofing.com mashed the following keys :> 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/ ------------------------------------------------------------- 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:
On a db with 10k records, wouldn't this be 20k searches? :) On 11/24/01 8:59 PM, Marc@lsaproofing.com mashed the following keys :> 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/ ------------------------------------------------------------- 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:
OT - good CC processor(s)? (1999)
Shared conversion under WebTen (1998)
checking for [ and ] in form fields ... (1997)
Multiple Users.db Possible? (1997)
Where's Cart Created ? (1997)
More questions about serial number dishing (1997)
Odd error in logs (1998)
Max Record length restated as maybe bug (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
test (2002)
Changes to [ReturnRaw] in 3.0 (1998)
[WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (2012)
Attn: Bug in GeneralStore example b15 (1997)
PCS Frames (1997)
Search Help Please (1998)
HomePage Caution (1997)
List Address Changed! (1998)
PCS Emailer's role ? (1997)
New public beta available (1997)
Snippet to calculate local time (2003)