I'm sure this is a less than optimum solution but for a relatively small db
it shouldn't be too slow. You could run a query then CFOUTPUT that query,
running another query inside and create a list of ID's that come up
matching...? Maybe
Certainly an interesting problem, a friend of mine had the same problem and
I think she solved it on list, maybe looking at the archives might help too.
Hopefully it's a start.
J.
John Wilker
Web Applications Consultant
Macromedia Certified ColdFusion Developer
www.red-omega.com <http://www.red-omega.com>
Pepsi's "Come Alive With the Pepsi Generation" translated into "Pepsi Brings
Your Ancestors Back From the Grave" in Chinese.
-----Original Message-----
From: Palyne Gaenir [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 23, 2001 11:28 PM
To: SQL
Subject: Listing duplicated records
I have an app where sometimes sometimes entries get duped, and I want
to run a utility to display all those records. I was looking through
count/sum/distinct functions but I'm not sure what to do here. I
want to say, "look through this table. Look at all the entries in
these two fields. If there is more than one record in this table
with the same values in those two columns as any other record, list
all those records for me." I don't even know where to start here,
since I don't actually have any particular value to WHERE by. Has
anybody ever done this?
Best regards,
PJ
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
