I've got a table that has several records where key
fields are duplicate and I need to remove the
duplicate row (note the entire row is not duplicate).
What I know I have to do is run a query on the
recordset, sort by the fields in question, and compare
two records at a time. If the second record is a
duplicate, get rid of it, and continue (loop). I know
that there is a way to move forward one record from
the one selected, which would allow me to compare the
key fields and remove the second one if necessary, but
not sure how to go about it. Can anyone help?
Thanks in advance,
Andrew
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
