Re: search for non-unique question

This WebDNA talk-list message is from

2001

It keeps the original formatting. numero = 40287
interpreted = N
texte = actually it can be up to 10k times 10k iterations :-)This search within search is the thing you need, Dale, however, I would puta max=1 in the INNER search, which would give you only one output fornicknames that are in there multiple times!Ciao,Peter----- Original Message -----From: Aaron Lynch To: WebCatalog Talk Sent: Sunday, November 25, 2001 11:39 AMSubject: Re: search for non-unique question> 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 tosearch> > 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 greaterthan> > 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 withinthe> > 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/>-------------------------------------------------------------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)

actually it can be up to 10k times 10k iterations :-)This search within search is the thing you need, Dale, however, I would puta max=1 in the INNER search, which would give you only one output fornicknames that are in there multiple times!Ciao,Peter----- Original Message -----From: Aaron Lynch To: WebCatalog Talk Sent: Sunday, November 25, 2001 11:39 AMSubject: Re: search for non-unique question> 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 tosearch> > 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 greaterthan> > 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 withinthe> > 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/>-------------------------------------------------------------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/ Peter Werno

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:

2.0 Info (1997) [Sum] function? (1997) WebCat2.0 [format thousands .0f] no go (1997) japanese characters (1997) Plugin or CGI or both (1997) [WebDNA] incomplete redirect tag (2009) Quickie question on the email templates (1997) [isfile] ? (1997) Tech question about web dna actions (1998) Making a page expire with web catalog? (1999) Re[2]: Next X hits (1996) Appending Information from one db to another (1998) RE: protect tag not working (1998) [WebDNA] Quick sort/results grouping Q (2008) Re:Emailer Set Up (1997) Thanks and Big News!!! (1997) Email Newsletters [OT] (2003) Multiple Pulldowns (1997) [input] formating (1998) RE: what characters are replaced for tab and CR? (1998)