Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2001
    Posts
    6

    Unanswered: vb data from a table

    Hi,
    I have a table as follows.

    QuestionNum | Answer | NextQuestion
    -------------------------------------------------------
    1 | Yes | 2
    1 | No | 3
    2 | True | 4
    2 | False | 4
    3 | Male | 5
    3 | Female | 6
    5 | One | 6
    5 | Two | 6
    5 | Three | 7
    6 | Yes | 7
    6 | NO | 7
    7 | Test1 | -
    7 | Test2 | -

    Given a QuestionNum i need to know all its NextQuestions.
    (or all its lower tier questions).

    I used a recursive function to solve the problem but it does not
    work. Any code or alogorithms would be appreciated.

    Any help would be helpfull,

    Thanks in Advance,

    Rann.


  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    You can do the following sql statement:

    select nextquestion from table where questionnum = 1 ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •