[thelist] Displaying survey results

[Ryan Finley]

Take a look at what SurveyMonkey generates for reports...it shouldn't be too
hard to replicate. ;)

Here is a report:
http://www.surveymonkey.com/Report.asp?U=158868194

Here is the survey itself (it's been running on the front page):
http://www.surveymonkey.com/s.asp?U=2621588

Not to be TOO self-promoting, but SurveyMonkey is really a nice tool.  The
original reason I developed it was because creating surveys was incredibly
tedious and boring.  I decided to create an entirely automated tool.

For learning, it would probably be good to create a survey yourself.
However, if you find yourself constantly creating surveys, then I'd look
around for some good survey software from myself or others.


	Ryan Finley
	President - SurveyMonkey.com


-----Original Message-----
From: Minh Lee Goon [mailto:v7ac at sdsumus.sdstate.edu]
Sent: Monday, March 19, 2001 6:37 PM
To: evolt
Subject: [thelist] Displaying survey results


I've been asked to create a survey in ColdFusion and then display the
results after the user has submitted his/her response. I was wondering
how I could go about displaying the results in the most efficient
manner.

The survey has a series of questions with four choices for each
question. The values for each option are a, b, d, and d, and the results
are inserted into an Access database as such. So for the rows in the
results table, each column will contain the value a, b, c, or d.

Here's my question: How do I display that information so that it's
understandable? It doesn't have to be graphical, just comprehensive. The
crudest method would be to query each column in the results database for
every possible option (i.e. four queries per question for each option,
using the WHERE clause in my SELECT statement) and then displaying the
results using RecordCount.

I hope I don't have to do that, but I was just wondering if anyone has
had any experience with displaying results of a survey similar to mine.
I would greatly appreciate any help you can give me.

Thanks in advance,
</ml>

---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !