If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Limit database inputs

How can I limit the data being sent to my database when it reaches a certain limit. In my case 10 people including their guess registering for a particular table. Or perhaps is their a better way to this event registration form. Please help

I am trying to create a registration form application that will allow a person to register for an event. I need the application to accept registration for attendee and three guests. Each attendee needs to choose any of the 60 tables for seating. Each table has a 10 person seating limit.

With the codes that I've written, How can I manipulate it in order to achieve such function with asp. Please help.

'check if the selected table reach the limit
sql="select count(*) from tblName WHERE tableno ="&Request.Form ("Table Number")
set MyRs=MyConn.execute(sql)
if myRs(0)<10 then' if the table not reach the limit
'your code here
else ' if the table reach the limit
'you code here
end if