Here's my GetSubjects query. It comes from another page and in called by a
CFINCLUDE tag.
<CFQUERY NAME="GetSubjects" DATASOURCE="#Request.maindsn#">
SELECT tbl_StudentGrade.GradesID, tbl_StudentGrade.SkillID,
tbl_CourseSkill.Skill, tbl_StudentGrade.GradeForSubject,
tbl_StudentGrade.SchoolDates, tbl_StudentGrade.Advisor,
tbl_StudentGrade.GradingPeriod, tbl_StudentGrade.GradingPeriod1,
tbl_StudentGrade.GradingPeriod2, tbl_StudentGrade.GradingPeriod3,
tbl_StudentGrade.GradingPeriod4, tbl_StudentGrade.PERMNUM
FROM tbl_CourseSkill, tbl_StudentGrade
WHERE tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and
PERMNUM='#PERMNUM#' And CourseID=1 OR
tbl_CourseSkill.SkillID = tbl_StudentGrade.SkillID and
PERMNUM='#PERMNUM#' And CourseID=2
Order BY tbl_StudentGrade.SkillID, GradingPeriod
</CFQUERY>
Janine M. Jakim
Database Programmer/Analyst
Albemarle County Public Schools
Department of Technology
Phone: (804) 975-9443
Fax: (804) 975-9442
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists