[thelist] Displaying survey results

Minh Lee Goon v7ac at sdsumus.sdstate.edu
Mon Mar 19 18:35:01 CST 2001


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>




More information about the thelist mailing list