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:

RE: boldwords funky (1998) Re:[ShowIf] and empty fields (1997) Search Order? (2000) syntax question, not in online refernce (1997) Error Lob.db records error message not name (1997) WebDNA-Talk Digests (1997) [WebDNA] OT: How is this being done? Curious. (2009) User/pass with tcpconnect (2000) Bug Report, maybe (1997) New commands in Final candidate (1997) possible, WebCat2.0 and checkboxes-restated (1997) Re[2]: Re[2]: running WebCatalog under Apache on NT? (2000) Number of Feilds Passed to [append] (2000) Virtual hosting and webcatNT (1997) Next (1997) Calculating multiple shipping... (1997) [isfile] ? (1997) Replace context problem ... (1997) [WebDNA] WebDNA glitch, no response required ... (2009) WebCatalog [FoundItems] Problem - AGAIN - (1997)