Hey everyone -
Arrgh. I haven't done any of these in a while, and I'm having a little bit of a brain
fart. Could somebody put these together in a join when the SQL table returned has the
following columns:
CandidateID, Num_Skills, BM_score
If I get the example then I think (hope? dream?) that my brain might start functioning
again like it should. :-)
<!--- For Number of Skills --->
<cfquery name="q_BM_score" datasource="datasource">
Select CandidateID, Count(*) AS num_skills
From CandidateSkills
Where CandidateSkills.CandidateID IN (#ListCandidateID#)
Group By CandidateID
</cfquery>
<!--- Query for skill points --->
<cfquery name="q_BM_score" datasource="datasource">
Select Sum(ExpYears) AS BM_score
From CandidateSkills
Where CandidateSkills.CandidateID = #Client_saSearch.CandidateID#
AND ((CandidateSkills.SkillID = #Skills1#)
OR (CandidateSkills.SkillID = #Skills2#)
OR (CandidateSkills.SkillID = #Skills3#))
</cfquery>
Thank you for your time in advance,
Stephen R. Cassady
[EMAIL PROTECTED]
http://www.ububik.com
http://www.tallylist.com <--- cause' you no you wannnnnnnna!
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
