Heya, Terri,
OK, admitted CF_Novice coming out of normal lurk mode, but heck, here's
what comes to mind. You may have already thought of this but want to do
it differently, but...
What about setting the coordinator's registration process to be able to
only approve 1 student at a time? That way, while in the registration
admin page, you can display the list of those waiting for approval, plus
the number of available slots. The coordinator approves a person, and you
give the standard " Mr.X Approved for class Y / approve another person /
back to admin main page" type page in return. And when the coordinator
says "yeah, I'll approve that other guy" you'll be pulling up your
refreshed counts, and if there are no available slots in the class, you
can show the appropriate "class full" message, and the person will not be
*able* to register more students than class slots.
Of course, the downside is if you're working with large classes, or a lot
of students. ;>
Is this something resembling what you want to do?
Hope this helps,
James~
-----Original Message-----
From: Terri Stocke [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 22, 2000 10:22 AM
To: CF-Talk
Subject: preventing overbooking of classes
Hi All,
Let me say in advance that this will be a lengthy description of my
problem,
as I believe the more info you have, the better position you will be in
to
help me...
<snip>
3) If the training coordinator tries to register a number of students
that
exceeds the maximum class size, I do NOT want the database to update and
I
do NOT want any emails to be generated until she goes back and modifies
the
form.
Now, somehow I need to determine which records from the form had a status
change, and what that status change was, BEFORE they are processed by my
update statement. I then need to take this new number and compare it to
the
database, and generate any error messages as appropriate based upon this
comparison. I tried using a loop and evaluate (without an update query)
to
set a new variable, but this did not work.
I'm thinking that my best bet would be to use a javascript on the actual
form page itself that evaluates all of the status changes in the
drop-down
menus and then utilizes my CF variables in that page for the maximum
seating
capacity, seats available, wait list, etc. So, I fear that the time has
come
for me to finally learn WDDX?
Does anyone have any examples of code that they could share to help me
out
with this? JavaScript is not my forte. In fact, I don't even know where
to
start.
Sorry for the lengthy explanation, but better to get it all out right
upfront...
TIA
Terri
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
