ASP Survey - Skipping Questions

[mitcho]

Hi guys. I have been creating an ASP survey based on an open-source survey by Guo Xu from planet source code. anyway, it is basically a multiple choice survey where users firstly enter their details, and then answer a series of multiple choice questions. You can see this here http://www.beaniekids.com/test/bkq2/user_details.asp . This survey uses an Access database which can be downloaded here: http://www.beaniekids.com/test/bkq2/survey.mdb

My Question is, How can i skip questions....

For example, the first question asks if a user is male or female.
If they answer MALE i want it to skip to Question 3 instead of going to Question 2. How can this be done. i have tried a number of times but cant seem to do it...

i have attached the text asp files for The questionnaire (which is one page that displays each question). i have also attached the proceed and tally asp text files which are called after each question is answered (if you need any more files let me know and ill post up).


And finally, one last question, is there a way to check if a user has answered a previous question. for example, right now i can go from Question 1 to Question 5 simply by changing the url in my browser to from .../p2_questionnaire.asp?QC=1 to ...//p2_questionnaire.asp?QC=5 < how can i prevent this kind of unwanted question skipping. Thanks

[spinal007]

answer is here:
http://forums.aspfree.com/showpost.p...88&postcount=2

[mitcho]

yes well i accidently clicked that response as the answer. i am unable to get it to work still so was hoping for soem help

[spinal007]

What have you done so far?
You can't just expect people to get the system you're using, set it up on their own machines, find out how it works, produce your desired effect and then post back....

That answer tells you the method you should use.
How have you decided to implement it? Have you done anything at all?

[mitcho]

Theres no need to get angry. I am extremely new to ASP, and forums are a place where experts connect. I do not think there is anything wrong with posting such a problem here in hope of a solution.

in answer to your question i have implemented most of this system already here: http://www.beaniekids.com/test/bkqf/...stionnaire.asp

i just cannot get the question skipping to work. i want the survey to automatically skip certain questions based on the previous answer. for example if they answer Question 3 'Male', i want the survey to go to Question 5 instead of 4 when the next button is pressed.

i posted up the code for the questionnaire page, proceed (which is called when the next button is pressed) and tally (which tallys up the answers at the end and saves them to database).

[spinal007]

Not angry... I appologize if it came across that way.

What I gathered from the code you posted is that you'll need something like this:

Code: Select all

If Answer='a' Then
 Server.Transfer ("/questions.asp?QC=5")
Else
 ' next question...
End If

Problem is:

Code: Select all

  <%
  Set rsQuery = Con.Execute("SELECT * FROM QDB ORDER BY ID ASC")
  For x = 1 To (Request.Querystring("QC") - 1)
      rsQuery.MoveNext
    If rsQuery.EOF Then Response.Redirect "error.asp?cs=Wrong querystring data. Possible cause: Manually edited?"
  Next
  Multiple = rsQuery("MultipleChoices")
  %>

This seems to require an answer for every question so you'll need to modify that too is you want this to work.



I'm not having a go but, that script is so badly coded I'd recommend you find another free questionnaire script - which might even already have the functionality you need.