Re: Opposite of Summ=T?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30644
interpreted = N
texte = Thanks for the response. Yes, these dupe's will be deleted. And for reasons that are long and winded, the dupe's are actually SKU's (big No-No I know :) that were allowed to happen with the originally written tpl's. For quick editing reasons, an error-correction code of making sure a newly submitted SKU isn't a duplicate is not feasable...again, long and winded. So, the best solution I can think of is to do a small page that will list all duplicate sku's that the administrator can use to delete the item they want. And then, they can run this page once a month or so to make sure no new duplicates cropped up.The big unfortunate is...that the client has no idea how to use a spreadsheet to import the database themselves and do a one time clean-up. Thus, I need to setup this new admin page for them.The way it looks now in the .db....there's probably about 30 SKU's that have just 1 duplicate of it.Thanks again! Gary----- Original Message ----- From: tech
To: WebCatalog Talk Sent: Wednesday, April 19, 2000 9:10 PM Subject: Re: Opposite of Summ=T? > 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 ------------------------------------------------------------- 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:
Thanks for the response. Yes, these dupe's will be deleted. And for reasons that are long and winded, the dupe's are actually SKU's (big No-No I know :) that were allowed to happen with the originally written tpl's. For quick editing reasons, an error-correction code of making sure a newly submitted SKU isn't a duplicate is not feasable...again, long and winded. So, the best solution I can think of is to do a small page that will list all duplicate sku's that the administrator can use to delete the item they want. And then, they can run this page once a month or so to make sure no new duplicates cropped up.The big unfortunate is...that the client has no idea how to use a spreadsheet to import the database themselves and do a one time clean-up. Thus, I need to setup this new admin page for them.The way it looks now in the .db....there's probably about 30 SKU's that have just 1 duplicate of it.Thanks again! Gary----- Original Message ----- From: tech To: WebCatalog Talk Sent: Wednesday, April 19, 2000 9:10 PM Subject: Re: Opposite of Summ=T? > 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 ------------------------------------------------------------- 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
Gary J. Krockover
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:
Sort of a Dilema! (1998)
upgrade? (1997)
lookup and two records? (1997)
Writefile (2000)
[ModDate] & [ModTime] ? (1997)
WebTen? (1997)
Write file (2000)
read and write you own cookies with webcat (1997)
W* 3.x & WebCat + WebMerchant (1998)
Help! WebCat2 bug (1997)
listfiles-looking for slick solution (1997)
Erotic Sites (1997)
For those of you not on the WebCatalog Beta... (1997)
Image as submit button (2000)
[shownext max=?] armed (1997)
Search in 2 or more catalogs (1997)
[WebDNA] Brian Harrington (2019)
WebDNA Trouble... (1999)
WebCat2b15MacPlugin - showing [math] (1997)
[date] for today's date, while inside old order file (1998)