The organization that I work for occasionally conducts surveys of our
membership. We'd like to start doing them online, so today I started
working on a system to automatically generate the HTML, perl, and
database files needed for a survey. The system uses three template
files--one each for HTML, perl, and MySQL (like what is generated by
mysqldump). When the generator script is run it queries a database to
pull a list of attributes that the survey should seek responses for as
well as descriptions for those attributes. It then fills in the
templates so that=20
1) a database can be easily created with:
unix prompt# mysql < survey.sql
2. a web page that can process the data and populate the database can
be quickly deployed with survey.htm and the associated survey.pl script
to pull from the correct fields on the form and insert them into the
I'm considering further generalizing my code so that it can be used
outside of our organization. Do any of you have any use for something
like this? What features would you be looking for?
From: Ron Savage <rons@de...> - 2003-07-04 01:34:40
On Thu, 3 Jul 2003 15:34:00 -0700, Tim Howell wrote:
>The organization that I work for occasionally conducts surveys=
>our membership. We'd like to start doing them online, so today=
>I'm considering further generalizing my code so that it can be=
>outside of our organization. Do any of you have any use for
>something like this? What features would you be looking for?
Great minds think!
which is my downsized :-) version of
Great minds think alike!
I've just put into production a pure Perl package which does just=
this. It's not documented, so won't be on CPAN for a little=
And the deadline for my Master's thesis is looming...
This is an educational package, to train efficient programmers,=
to be 'efficient'. It's a very round-about way to fabricate HTML,=
1 You create an XML file containing the questions, form action,
HTML::Template path, answer types, ...
2 You run a script which parses it via SAX and stores it in a db=
3 You run a CGI script which read the db via DBI and constructs=
HTML pages via HTML::Template
Sample output from the CGI script (with a dummy action!) is here:=
Is this what you have in mind?
Ron Savage, rons@... on 4/07/2003. Room EF 312
Deakin University, 221 Burwood Highway, Burwood, VIC 3125,=
Phone: +61-3-9251 7067, Fax: +61-3-9251 7604