Create a survey

I need to create a survey in ASP. I have the database and am having a
hard time deciding how to make the survey as dynamic as possible. Does
anyone know of any online tutorials for survey creation? I am using ASP,
VBScript. Thanks!
--


Seth Meranda
smeranda2<at>unl<dot>edu

I need to create a survey in ASP. I have the database and am having a
hard time deciding how to make the survey as dynamic as possible.

What do you mean 'dynamic'?

What are you specifically trying to do?

-Darrel

I am looking to create a survey "application." An admin will be able to
add the survey questions and answers. Then a page will be available for
a user to fill out the survey (all the questions will be multiple choice
with radio buttons). Then another page will be available with the totals
and possibly bar charts for the results (seen only by the admins).

Seth
--


Seth Meranda
smeranda2<at>unl<dot>edu

I am looking to create a survey "application." An admin will be able to
add the survey questions and answers. Then a page will be available for
a user to fill out the survey (all the questions will be multiple choice
with radio buttons). Then another page will be available with the totals
and possibly bar charts for the results (seen only by the admins).

Ah. Well, I suppose general tutorials that involve databases would work.

I suppose I'd make a few tables:

surveys

questions

answers


The survey table would store survey information (author, about)
The questions would be the questions
the answers would be the answers for each question.

So, I'd google 'multi-table database tutorial' or something of the start to
get you going.

-Darrel

Darrel:

Thanks for the reply.

I know how to build the database... before I built it though, I wanted
to know what direction to take. I was hoping to answer that by looking
at some different possible ways of putting the survey together with the
ASP script.

For instance, can I do a couple of repeat regions? (one for the answers
available for each survey question and then another repeat region for
all the questions and answers).

I have/will have more questions as this progresses, but wanted to see
how other people are building their surveys.

Thanks!
--


Seth Meranda
smeranda2<at>unl<dot>edu