What is WebDNA

WebDNA is a scripting and database system designed to easily build web applications.

WebDNA and BioType

BioType service is a biometric keystroke dynamic system. It will be part of WebDNA 8.5

Download WebDNA

Download WebDNA freeware, try it and register later if you want.

WebDNA resources

The list of all WebDNA instructions.
WebDNA
Software Corporation
Search WebDNA Site
 Menu


HOME


DOWNLOADS


LEARN


EDUCATION


NEWS


COMMUNITY


STORE


SUPPORT


CONTACT

Re: search for non-unique question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40284
interpreted = N
texte = 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/ 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)
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/ Marc@lsaproofing.com

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:

Multiple Pulldowns (1997) WebCat2 - Getting to the browser's username/password data (1997) Odd [math] behaviour (2003) French Webcat User (2002) Verify entry into a text field (2005) WC 4.02rc2 (2001) WebCat2 - [format thousands] (1997) Emailer Problem (2000) gateway application timeouts (1998) RE: protect tag on NT (1997) webcat/webmerchant docs (1997) .. more on sliding discounts... (1997) [Fwd: F3 database munching] (1997) Cache Access Error (2000) Attn: Bug in GeneralStore example b15 (1997) Databases inside [SHOWIF] (1998) AOL and webcat (1998) What is WebDNA (1997) autosensing lanague selection (1997) WSDL Wizard (2003)