- see footer for list info -<
There's no JS on the page .....
Its just a query ......
<cfparam name="form.Select_Phase" default="0">
<cfparam name="form.Select_Place" default="0">
<cfparam name="form.Select_Skill" default="0">
<CFQUERY NAME= "results" DATASOURCE="#Application.StudySupportDSN#">
SELECT dbo.tblActivities.Activity,
dbo.tblPhase.PhaseIDPK,
dbo.tblTakesPlace.TakesPlaceIDPK,
dbo.tblSkills.SkillsIDPK
FROM dbo.tblSkills
INNER JOIN dbo.tblActivityToSkills ON dbo.tblSkills.SkillsIDPK =
dbo.tblActivityToSkills.SkillsIDFK
INNER JOIN dbo.tblActivities
INNER JOIN dbo.tblActivityToPhase ON dbo.tblActivities.ActivityIDPK =
dbo.tblActivityToPhase.ActivityIDFK
INNER JOIN dbo.tblPhase ON dbo.tblActivityToPhase.PhaseIDFK =
dbo.tblPhase.PhaseIDPK
INNER JOIN dbo.tblActivityToTakesPlace ON dbo.tblActivities.ActivityIDPK =
dbo.tblActivityToTakesPlace.ActivityIDFK
INNER JOIN dbo.tblTakesPlace ON dbo.tblActivityToTakesPlace.TakesPlaceIDFK =
dbo.tblTakesPlace.TakesPlaceIDPK
ON dbo.tblActivityToSkills.ActivityIDFK =
dbo.tblActivities.ActivityIDPK
GROUP BY dbo.tblActivities.Activity,
dbo.tblPhase.PhaseIDPK,
dbo.tblTakesPlace.TakesPlaceIDPK,
dbo.tblSkills.SkillsIDPK
HAVING (dbo.tblPhase.PhaseIDPK = #form.Select_Phase#)
AND (dbo.tblTakesPlace.TakesPlaceIDPK = #form.Select_Place#)
AND (dbo.tblSkills.SkillsIDPK = #form.select_Skill#)
</CFQUERY>
<table border="0" class="itemTable" width=100%>
<tr>
<td valign="top">
<cfif results.recordcount gt 0>
<cfoutput query="results">
#Activity#<br>
</cfoutput>
<cfelse>
Nothing Found ...!
</cfif>
</td>
</tr>
</table>
Regards - Paul
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
