|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Limit Class Enrollment to 20 |
|
From: |
Scott Ott |
|
Date: |
3/15/2000 12:31:17 PM |
|
IP: |
24.94.163.192 |
Im making a web form to enroll folks in 50 sections of a single course. The
database table has a field called Section. The user will input the section number along with his name.
The Challenge: I want the user to get rejected if there are already 20 people in the class. So, the ASP needs to count the number of times the
user-submitted variable Section occurs in the Section field, and return
a rejection message if that number is greater than 20.
Background: I know I can do this inelegantly if I just create a table for each section and set the validation rule to kick in at [ID]>20 where ID is
an autonumber field. But Id rather do this with one table, not 50.
A Twist: I do most of my stuff in FrontPage 2000, and it doesnt like me messing with the ASP coding. So, Im guessing Ill have to code the whole thing from scratch...and Im none too bright when it comes to that.
Copy your response to my e-mail address if possible.
Thanks,
Scott Ott
scott.ott@twcable.com
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
