February 8th, 2013, 03:10 PM
Anyone know a good tutorial/link for limiting the amount of users that can register for an event? For example, after 150 people register, the page will let you know that registration is full and can no longer accept more.
February 9th, 2013, 12:32 AM
I suppose there are several ways to do that. One easy way would be to put this code at the top of the form page:
set objConn = server.CreateObject("adodb.connection")
SQL = "SELECT SUM (UserNameField) from YourTable Name"
Set objRS = objConn.Execute(SQL)
if objrs("UserNameField") >150 then
response.Write "Sorry registration is full"
or you could do a redirect instead of a message.
February 11th, 2013, 12:10 AM
Brinkster- free development account. Not affiliated, but I sure like free. Brinkster.com
February 14th, 2013, 07:28 PM
I agree with you, thanks for the help in this question. As always all ingenious is simple.
February 21st, 2013, 08:26 AM
Thanks Phoenix for your answer! Much thanks!