sql server clients:

Wow ! Let me try to put in some of my thoughts, but you are the best judge
of what to choose.

a) First, I am assuming that you will ask the visitors to fill out the
personal information first, before allowing them to participate in quiz. So
lets assume that I visit your website and I click on the link which takes
me to the online quiz. The first ASP page (I am again assuming that you
will be using either ASP or ASP.NET) will show a form to the user wherein
they can fillin their personal information like Name, address, email,
telephone etc. Now, the only validation that you can do is to ensure data
integrity in each field. For example, you can use JavaScript to check
whether the visitor has entered the telephone number is a correct format or
not.

The way to go about this would be to create a JavaScript function that is
called when the visitor clicks on the first "next/continue" button on the
info page. This function will pick the info in the text fields and will
check its integrity as to whether the information is in a valid format or
not (telephone number to be numeric only, name to be text only etc.)

This way you will be able to ensure that visitors are providing the correct
information.

I am also thinking if the person's information is already stored in the
database and you only want them to edit it, in case it is wrong. In that
case, you will allow the visitors to provide you with some userid and
password, which will be searched in your database adn their relevant
information will be shown to them on a webpage in text fields. This can be
done by simply populating the text fields with the values from the database
table. Once they update their information, then you will run an update
query to update those fields in your database.

b) For all quiz quetions, all you need to do is to either create a static
webpage with all the questions already embedded in HTML. When they click on
Continue, the javascript function will check whether the answers are
correct or not. If not, they will be prompted to correct them. If they are
all correct, you will then run an update query through an intermediate ASP
file that will update the information in the database.

I hope that helps.

Sanchan [MSFT]

sanchans@online.microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.