Survey and SQL

Hello, I develop a survey form with questions/answers.I have many multiple choice and multiple response questions . The content of form come from SQL tables, a kind of dynamic form, because the list of question depends on the user and I can not create a static form. I see two solutions :I develp a form, and with javascript I run few sql query "client side", Or I build a new livelink module, with SQL query "server side", but it's more complex.Do you know another method/solution , have you a feedback ?thanks by advance.C.

Find more posts tagged with

Comments

Hans_Stoop_(hstoop_(Delete)_1579932)

Message from Hans Stoop <hstoop@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

You can use different HTML views depending on the user.

Hans

From: eLink Discussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: dinsdag 1 maart 2005 11:59
To: eLink Recipient
Subject: Survey and SQL

Survey and SQL Posted by EU0014029User1 (Laforest, Jacques) on 03/01/2005 05:58 AM

Hello,

I develop a survey form with questions/answers.

I have many multiple choice and multiple response questions . The content of form come from SQL tables, a kind of dynamic form, because the list of question depends on the user and I can not create a static form.

I see two solutions :

I develp a form, and with javascript I run few sql query "client side",

Or I build a new livelink module, with SQL query "server side", but it's more complex.

Do you know another method/solution , have you a feedback ?

thanks by advance.

C.

Greg_Petti_(gpetti_(Delete)_2694690)

Message from Greg Petti <gpetti@opentext.com> via eLink

eLink

Hi Jacques,

We have delivered applications where weuse WebReports (in conjunction with WebForms) to provide this type offunctionality. WebReports (with version 3.0+) allow multiple subqueries so thatdata from multiple SQL tables can be used to build select statements etc. onthe server side. WebReports can also be used to run in iframes orsubwindows to retrieve data and present it accordingly from the client. Insome cases we popup a window with a WR running inside so that a list of itemscan be used to select from and fill into a form field (like the targetbrowser).

If you require any more detail orexamples, let me know.

Greg Petti

Office: +1 403 685 9126

Cell : +1 403 608 7392

From: eLinkDiscussion: Development Discussion [mailto:development@elinkkc.opentext.com]
Sent: March 1, 2005 3:59 AM
To: eLink Recipient
Subject: Survey and SQL

Survey and SQL

Posted by EU0014029User1 (Laforest, Jacques) on 03/01/2005 05:58 AM

Hello,

I develop a survey form with questions/answers.

I have many multiple choice and multiple response questions . The content of form come from SQL tables, a kind of dynamic form, because the list of question depends on the user and I can not create a static form.

I see two solutions :

I develp a form, and with javascript I run few sql query "client side",

Or I build a new livelink module, with SQL query "server side", but it's more complex.

Do you know another method/solution , have you a feedback ?

thanks by advance.

C.