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
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
