Duplicates 1

[NetworkGuy101]

Is there a way for me to get duplicate record that match certain criteria. Like only if there are duplicates in the subjectid field and criteriaid field? Help is appreciated.

Thanks,
Joe

 

[GUJUm0deL]

NetworkGuy101, create a query that returns all results via using the SQL LIKE.


____________________________________
Just Imagine.

http://www.imajinarts.com

 

[imstillatwork]

or did you want to compare every record against every record to find duplicates in a givin field?

 

[NetworkGuy101]

compare every record against every records to find matching duplicates thats what i want. I actually want to find where there are duplicates in 2 fields in every record.

 

[r937]

select subjectid
     , criteriaid 
     , count(*) as howmanydupes
  from yourtable
group 
    by subjectid
     , criteriaid 
having count(*) > 1

rudy

http://r937.com/

SQL Consulting

 

[NetworkGuy101]

I ran your code Rudy and got the following error:
Attribute validation error for tag CFQUERY.
The tag does not allow the attribute(s) NAMES. The valid attribute(s) are BLOCKFACTOR,CACHEDAFTER,CACHEDWITHIN,CONNECTSTRING,DATASOURCE,DBNAME,DBPOOL,DBSERVER,DBTYPE,DEBUG,MAXROWS,NAME,PASSWORD,PROVIDER,PROVIDERDSN,SQL
Here is my query:
<cfquery names="getdups" datasource="checklists">
select subjectid , criteriaid , count(*)
from Answers18OG
group by subjectid , criteriaid having count(*) > 1
</cfquery>
<cfdump var="#getdups#">

 

[NetworkGuy101]

Sorry Rudy I had a in my name attribute. Your code worked great thanks! Joe

 

[r937]

dude, it's <cfquery name="getdups

you have <cfquery names="getdups





rudy

http://r937.com/

SQL Consulting