Re: search for non-unique question

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 40324
interpreted = N
texte = This makes no sense to me: On 11/26/01 9:15 AM, Brian Fries mashed the following keys :> Faster than doing 10,000 searches: > > [text]lastNickName=[/text]OK, so now lastNickName = ''> [search > db=database.db&neNickNamedata=[blank]&allhit=1&asNickNamesort=1][founditems]OK, you just did a search, with 10,000 results...> [showif [url][NickName][/url]=[url][lastNickName][/url]]If 'nick'='' ?? This will only tell you if it's blank, which it won't be cuz you are searching for non blank entries. > ** [NickName] ** is duplicated > [/showif] > [text]lastNickName=[NickName][/text] > [/founditems][/search] > > - brian > > At 11:54 AM +0000 11/24/2001, 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/ 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 makes no sense to me: On 11/26/01 9:15 AM, Brian Fries mashed the following keys :> Faster than doing 10,000 searches: > > [text]lastNickName=[/text]OK, so now lastNickName = ''> [search > db=database.db&neNickNamedata=[blank]&allhit=1&asNickNamesort=1][founditems]OK, you just did a search, with 10,000 results...> [showif [url][NickName][/url]=[url][lastNickName][/url]]If 'nick'='' ?? This will only tell you if it's blank, which it won't be cuz you are searching for non blank entries. > ** [NickName] ** is duplicated > [/showif] > [text]lastNickName=[NickName][/text] > [/founditems][/search] > > - brian > > At 11:54 AM +0000 11/24/2001, 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/ 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:

trouble updating records in database (1998) Serving images from databases (1998) Text data with spaces in them... (1997) WebCat2final1 crashes (1997) redirect from the errorsMessages.db entry (1997) Webcat no longer supported? (2006) Re:trouble (1997) Problems reading files created by WC (1997) WebMerchant 3.0 for Mac shipping now (1998) Command=Showcart? (2000) Problems mit mysql (2004) WebCat and WebTV (1997) catagories (1997) [redirect] question (2005) WCS Newbie question (1997) Clearly.home (1998) problems with 2 tags (1997) webcat2b12 CGI -- Date comparisons (1997) searching within same page (2000) 2 problems with WebCatalog on Solaris (2001)