Re: Opposite of Summ=T?
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30714
interpreted = N
texte = Alex, yes, this client is using a Mac and does have FMPro...I shoulda thought of that!Thanks, Gary----- Original Message ----- From: Alex McCombie
To: WebCatalog Talk Sent: Thursday, April 20, 2000 8:17 AM Subject: Re: Opposite of Summ=T? > 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 ------------------------------------------------------------- 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:
Alex, yes, this client is using a Mac and does have FMPro...I shoulda thought of that!Thanks, Gary----- Original Message ----- From: Alex McCombie To: WebCatalog Talk Sent: Thursday, April 20, 2000 8:17 AM Subject: Re: Opposite of Summ=T? > 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 ------------------------------------------------------------- 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:
Flash Stores (2003)
[WebDNA] Limited Time Discount on WebDNA Server licenses (2013)
What's going on???? (2000)
Sorting error (1997)
Multiple Pulldowns (1997)
[WebDNA] Retrieving a PDF from an email (2008)
Sort Order on a page search (1997)
[OT] (2002)
WebCommerce: Folder organization ? (1997)
[WebDNA] opinions on [switch] [case]... (2009)
Loss in Form (1998)
Nested tags count question (1997)
Using [setlineitems] after a purchase command ... (1997)
japanese characters (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
user flush db (2002)
Still can't interpret encrypted templates. (2003)
Setting up WebCatalog with Retail Pro data (1996)
Clear/Reset form with JavaScript (2001)
Webcatalog error, Plug-in for Webstar (1996)