Ok maybe because it's early and the coffee hasn't kicked that I can't come
up with a solution for this....
I am making dynamic contracting menus for our school. This is for teachers
such as math/science/music/band who have many students, but not all the
students in the school. I want them to only see their students.
They requested that the students be listed by Homeroom teacher- Like so.
They click on the teacher and see the students.
Mrs. Smith
Tom Jones
Leigh Smith
Kate Lee
Mrs. Jones
Rob Reed
Julie Jules
etc....
Mr. Andres
Ms. Bell
I'm having problems filtering my sql queries correctly to get the
students....and either end up with all the students from all the homerooms
or only the students listed under the teacher. (ie the math teacher will
also have their own homeroom so s/he'll see all the math students listed
under his/her name..)
I have one query that gets all the homeroom teachers.
What I need:
All the students associated with the math/science/etc. teacher (hooks by a
teacherID)
and have them sorted by their homeroom teacher (teacherID)
How the database is set up:
Teachers are assigned according to subject and have a code. So there is a
table that hooks teacherID, StudentID, ClassCode. So a student can have
many different teachers....
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
