The problem still is having some way to roll back that count if they don't complete the registration.
-- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com > From: Bill Conlon <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Mon, 30 Dec 2002 11:47:57 -0800 > To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]> > Subject: Re: Witango-Talk: Courses Full? > > First, the hyperlink to a course registration is only active if the > course is not full. > > Next, when you follow the hyperlink, it inserts a record with the course > id. This is a place holder record that will be updated when the > registration is complete. Any subsequent attempts to access the course > will depend on whether the maximum number has been reached. > > The Mom completes the registration, and the updates are written. > > If Mom has two kids to register, there may not be room for both. Of > course if she's clever and is reading this thread, she'll open up two > browser windows so that she gets her records inserted at 8am. > >> Looking for suggestions. >> >> I have a community school application that allows users to sign up for >> courses on line. For 90% of the courses the max amount of classes is not >> critical. One or two over makes no difference. And class demand is not high. >> >> Therefore this system works fine. >> >> When a user selects a course it is put in their basket. >> >> When the pay for the course(s) the course count is increased by one and if >> it is = or > course max then course is closed. >> >> But now we are adding these kids swim program courses. They are limited and >> highly competitive to get in. Probably 150 people will sign up kids between >> 8 and 10 AM the 1st day. >> >> My problem is how to keep the course count accurate when they sign up more >> than one kid in their family. >> >> So here is the scenario. >> >> Mrs. Smith has 3 kids >> >> She logs into the site and goes to registration >> >> She gets a drop down list of her family members. >> >> She picks bill and swimming and puts course 1401 in her basket ( there is >> room for 32 kids and bill makes number 32) >> >> She then goes to add Jill >> >> She selects the same course >> >> Without counting Bill it is still open but in reality if she were to pay for >> Bills course now it would be closed. >> >> The system will think it is open and allow her to add Jill but now we are >> one over. >> >> >> The other issue is with so many people signing up at once while a course is >> open when you 1st sign up by the time you get to the checkout it might be >> closed. >> >> I can deal with this last one I guess by checking the course count again >> before checkout and if the course is now closed show them that and wait list >> them removing the charge. >> >> Any other thoughts on how to handle this? >> >> >> -- >> Dan Stein >> Digital Software Solutions >> 799 Evergreen Circle >> Telford PA 18969 >> Land: 215-799-0192 >> Mobile: 610-256-2843 >> Fax 413-410-9682 >> FMP, WiTango, EDI,SQL 2000 >> [EMAIL PROTECTED] >> www.dss-db.com >> >> >> ________________________________________________________________________ >> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] >> with unsubscribe witango-talk in the message body >> > > > Bill Conlon > > To the Point > 345 California Avenue Suite 2 > Palo Alto, CA 94306 > > office: 650.327.2175 > fax: 650.329.8335 > mobile: 650.906.9929 > e-mail: mailto:[EMAIL PROTECTED] > web: http://www.tothept.com > > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body > ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
