Re: Schema for a survey data collection?

Carlos Bromanski wrote:

> What a great idea!
> Is there any way for you to share more details of your implementation to the
> newsgroup?
> For example, what language is the application written in? How are the forms
> rendered?

Thanks..
The Database used is DB2 UDB V7.1 The XML specs are stored as varchars in a table.
A java servlet uses jdbc to retrieve the questions from the tables and merges them into a single XML tree.
This tree is fed to Apache/Xerces XML parser to create an in-memory DOM object. The dom tree is walked using the recursive tree traversal technique(or Visitor Pattern of GoF). At each node, the node is processed using the Inline/SQL/Custom options.

This expanded XML tree is then processed using an XSL stylesheet, using Apache/Xalan processor. The XSl Stylesheet is an externally maintained file, which actually specifies how each node in XML is rendered. Basically, XML+XSL=HTML. The HTML is written to the client to display the form.

Unfortunately, I can not give you the actual code, due to the contractual obligations.

HTH. Received on Sun Jul 22 2001 - 01:32:08 CEST