HELP: Interesting Design Problem!?

Article View: alt.comp.databases

Article #131

Back to alt.comp.databases Previous Next

#131

From: Joshua Lippiner
Date: Thu, 21 May 1998 00:00

24 lines
2426 bytes

To anyone who can figure this out;

I have an interesting problem.  I am trying to create a SQL database that
will be used for online surveys.  To do this, I will be creating a separate
table with the survey (online form) definitions such as name, value and
type.  This dB will be read and made into an online form.  That part is
background and fairly trivial.

Here's the problem;
I want to add something called a skip ruled.  What this will do is ask
different questions based on different responses to a specific question.
Example:  If you are male than which of these deodorants to you use.  The
choices would be different if the person was female.  The problem is that I
want all of the skip rules to be defined in the database somehow.  Meaning I
want my form creator to be able to read my SQL table and know which
questions to ask next if this response is given.

Does anyone have any idea how I should go about setting up this system?  I
know I can have a table with the survey structure but dont know how to
reference in the skip rule to specific responses.  Thanks for the help.
please reply directly to jlippiner@iname.com

Josh Lippiner

Technical Details

Message-ID: <6k1ljr$pmq$1@winter.news.erols.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 105c7d,8a3951f7eafce14c,start
X-Google-Attributes: gid105c7d,public
X-Google-Thread: 10a90d,8a3951f7eafce14c,start
X-Google-Attributes: gid10a90d,public
X-Google-Thread: fc5c9,8a3951f7eafce14c,start
X-Google-Attributes: gidfc5c9,public
X-Google-Thread: 104de1,8a3951f7eafce14c,start
X-Google-Attributes: gid104de1,public
X-Google-Thread: 10d3ce,8a3951f7eafce14c,start
X-Google-Attributes: gid10d3ce,public
X-Google-Thread: 1162a5,8a3951f7eafce14c,start
X-Google-Attributes: gid1162a5,public
X-Google-Thread: ff5a1,8a3951f7eafce14c,start
X-Google-Attributes: gidff5a1,public
From: "Joshua Lippiner" <jlippiner@iname.com>
Subject: HELP: Interesting Design Problem!?
Date: 1998/05/21
Message-ID: <6k1ljr$pmq$1@winter.news.erols.com>
X-Deja-AN: 355278712
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
X-Complaints-To: abuse@erols.com
X-Trace: winter.news.erols.com 895769019 26330 207.172.165.33 (21 May 1998 16:43:39 GMT)
Organization: Erol's Internet Services
Newsgroups: alt.comp.databases,borland.public.vdbase.data.sql,borland.public.vdbase.non-technical,borland.public.vdbase.programming,comp.databases,comp.databases.ms-sqlserver,comp.databases.visual-dbase