Re: Opposite of Summ=T?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30662
interpreted = N
texte = on 4/19/00 10:35 PM, Gary J. Krockover at gkrockover@austin.rr.com wrote:Duplicate SKU's? Ominous thunder stage left.Gary, are you on a MAC? If so, get a copy of FMPRO. I still keep one around for managing certain WebCat dbs. Yes you can code most of it, all right all of it, in WebCat, but for quick cleaning, changing and exporting to tab files for WebCat serving FMPRO does a great job.Besides, gives me great pleasure to reduce FMPRO to a complicated and bloated text editor.Alex> 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 . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
on 4/19/00 10:35 PM, Gary J. Krockover at gkrockover@austin.rr.com wrote:Duplicate SKU's? Ominous thunder stage left.Gary, are you on a MAC? If so, get a copy of FMPRO. I still keep one around for managing certain WebCat dbs. Yes you can code most of it, all right all of it, in WebCat, but for quick cleaning, changing and exporting to tab files for WebCat serving FMPRO does a great job.Besides, gives me great pleasure to reduce FMPRO to a complicated and bloated text editor.Alex> 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 . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Alex McCombie
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:
Re1000001: Setting up shop (1997)
Multiple prices (1997)
[WebDNA] Test (2009)
WebCat2b12plugin - [search] is broken ... not! (1997)
Ready,Set; Print! (1999)
possible bug in unix version? (2000)
WebCatalog for Postcards ? (1997)
Enterprise Server (1998)
Custom formulas.db (1998)
WebCat2.0 [format thousands .0f] no go (1997)
Strange database format import (2000)
problems with 2 tags shakur (1997)
Date Sorting (1997)
webcat- multiple selection in input field (1997)
WebDNA Solutions ... sorry! (1997)
[SearchString] usage (1997)
[browsername] (2001)
Emailer (1997)
[WebDNA] Webdna, Css & ie (2011)
WebCat2 - [format thousands] (1997)