ok, so you want to get all the students that a given teacher has in
class, but grouped by their homeroom teacher?
you'll probably have to do this in two statements, as the linking table
has both elements in it:
SELECT
<all the students the logged in teacher has in the given class>
then
SELECT
<the homeroom teacher of each student returned by the first
statement>
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 11:54 AM
To: CF-Talk
Subject: RE: Contracting menus
It does have a class code also. So to get a homeroom class you need
teacherID and HomeCode=Home
I'm just confused on how to group the students in their homeroom teacher
while being accessed by other teacher....
-----Original Message-----
From: Christopher Olive [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 27, 2001 11:52 AM
To: CF-Talk
Subject: RE: Contracting menus
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
