PDA

View Full Version : vb data from a table


ran
11-26-02, 17:23
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.

:(

rnealejr
11-26-02, 22:50
You can do the following sql statement:

select nextquestion from table where questionnum = 1 ...