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:

Re: search for non-unique question (Brian Fries 2001)
Re: search for non-unique question (Aaron Lynch 2001)
Re: search for non-unique question (Brian Fries 2001)
Re: search for non-unique question (Peter Werno 2001)
Re: search for non-unique question (Dale Therio 2001)
Re: search for non-unique question (Aaron Lynch 2001)
Re: search for non-unique question (Marc@lsaproofing.com 2001)
Re: search for non-unique question (Aaron Lynch 2001)
search for non-unique question (Dale Therio 2001)

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!

Re: search for non-unique question

2001

Top Articles:

Related Readings: