add a class code for homeroom. treat it like a class. christopher olive, cto, vp of web development cresco technologies, inc 410.825.0383 http://www.crescotech.com
-----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 9:26 AM To: CF-Talk Subject: Contracting menus 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.... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
