Re: Opposite of Summ=T?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30639
interpreted = N
texte = I was just reading your question, and I was thinking that you could maybe do something with the numfound function.In other words if the number of items found were greater than one, then you could make a list of them by showing them.So what if you made a summery of your zip codes, and then did a search on everyone.When you searched for a particular zip code look at the number found in this second search and if it was greater than one that would give you a list of all the repeated zip codes.I am thinking that you just want to find them so you can delete them or something right? Cause this would use up a lot of processor time if you did it constantly.jaks>Hey all, > This has become a little more perplexing than I would like. Situation: >I'm wondering if there is a simple way to find ALL records in a database >that have duplicate's in a certain field. Example; I want a search results >that will return all ZipCode that have duplicate's and to not show the rest. >I'm not searching for just one ZipCode at a time either, I want the full >list of duplicates. As in: >Name ZipCode >Tom Jones 90012 >Haray Caray 90012 >Joe Smith 90014 >Jane Doe 90014 >etc... >Basically, it would be the exact opposite of what Summ=T does in a search. > >Any advice would be appreciated! >Gary > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list <WebDNA-Talk@talk.smithmicro.com>. >To unsubscribe, E-mail to: <WebDNA-Talk@talk.smithmicro.com> >To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.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
Associated Messages, from the most recent to the oldest:
I was just reading your question, and I was thinking that you could maybe do something with the numfound function.In other words if the number of items found were greater than one, then you could make a list of them by showing them.So what if you made a summery of your zip codes, and then did a search on everyone.When you searched for a particular zip code look at the number found in this second search and if it was greater than one that would give you a list of all the repeated zip codes.I am thinking that you just want to find them so you can delete them or something right? Cause this would use up a lot of processor time if you did it constantly.jaks>Hey all, > This has become a little more perplexing than I would like. Situation: >I'm wondering if there is a simple way to find ALL records in a database >that have duplicate's in a certain field. Example; I want a search results >that will return all ZipCode that have duplicate's and to not show the rest. >I'm not searching for just one ZipCode at a time either, I want the full >list of duplicates. As in: >Name ZipCode >Tom Jones 90012 >Haray Caray 90012 >Joe Smith 90014 >Jane Doe 90014 >etc... >Basically, it would be the exact opposite of what Summ=T does in a search. > >Any advice would be appreciated! >Gary > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list <WebDNA-Talk@talk.smithmicro.com>. >To unsubscribe, E-mail to: <WebDNA-Talk@talk.smithmicro.com> >To switch to the DIGEST mode, E-mail to <WebDNA-Talk-digest@talk.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
tech
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:
Make sure I understand this??? (1997)
FlushDatabase Suggestion (1998)
Can't use old cart file (was One more try) (1997)
WC2b15 File Corruption (1997)
Change to 5.0 per website licensing (2003)
two part electronic product (1998)
Line items in table cells (1997)
Why do extra quotation marks sometimes appear in my databases? (1998)
Help name our technology! (1997)
Problem using # in my field names ... (1998)
Why does setheader provide a db= parameter? (2005)
Re:Part 2 - [showif] if variable exists (1998)
Webcatalog/ColdFusion/Tango (1998)
WC 2.0 frames feature (1997)
Field name-subcategory (1997)
[/application] error? (1997)
A sendmail warning (2005)
Refreshing document (2000)
Server slowing down. (1997)
emailer (1997)