create registration application that limits number of registrants

Question

I'm trying to create a registration system with Dreamweaver
CS3, an Access database, and using ASP VBscript. I want users to be
able to enter their contact info on a form that inputs to an Access
DB. I have that part working. On the next page, I want them to
choose from ten different dates that a session is held. Each date
is limited to 85 attendees. I'm having difficulty figuring out how
to capture the number of people who have selected a particular date
in Access. The various contact info and the person's selected date
are currently entered into a table (registrants). But I don't know
how to capture the total number of people who selected a particular
date so that I can use that info in DW to either hide a particular
date, or show a date for more registations. Is there any way in DW
to use a script that will count how many of a like record are in a
particular field in a table? If so, how would I do that? Thanks for
ANY guidance.

brokenTurtle · Answer

HiI have created similar apps for conferences where eachsession at the conference is limeted to a certain number ofdelegates.. The way i did it was to create a query in the AccessDBwhat Groups the Dates and counts the delegates. You can then usethe query in dreamweaver in the same way as tables.. if you thinkabout the results you can use this query (or another) to restrictthe options availble to users.. Perhaps write a different querythat only returns results if the count is less than the requirednumber and then use this to dynamically drive a drop down list ofdates. When a day is full the option will automatically dissapear..This shoud point you in the right direction. I ended up with loadsof hand coded VB script in the end...!

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.