A teacher needs to set up their classlists- both as the main teacher and peripheral teacher. Several teachers can have the same students. Maybe I'm blind but I don't see how to set it up in the gui. I had planned to have a select box that a teacher could use to pick multiple students at one time. Then I was going to have a check box to check if they are the main teache for the studens. Should I do 2 selects instead- one with students eligible to have a main teacher and the other for those who can only be chosen as a 2ndary teacher...or should I "separate out the pages"- have 2 different links going onto the page- one if they are going in to make their list as a main teacher and the other if they are going to make their secondary list.
-----Original Message----- From: Bryan Love [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 12:47 PM To: CF-Talk Subject: RE: loop query check??how to do this The GUI should not allow you to choose to be the mainteacher for students who already have one... It seems to me that the error lies in the GUI and should be fixed there, not behind the scenes. +-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst TeleCommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis "Let's Roll" - Todd Beamer, Flight 93 -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 11, 2002 9:02 AM To: CF-Talk Subject: loop query check??how to do this I have a table- that users can add to their classlist. When adding they can choose multiple students. I can easily do that loop. My prob. Each student will have only one MainTeacher and many peripheral teachers So before a student is added to a classlist it would need to be checked if there's any conflict- that 2 teachers are claiming to be the MainTeacher. So what should happen if 1. one of the 10 students I chose and checked as MainTeacher is already in the db as having a different MainTeacher? How does that fit into the loop?? Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
