We ran an election for our Student Body off of our DNN site using the survey module. The Student Government Association is wanting to know how many people actually voted. In what table on the SQL Side could I look at to see who voted and who didn't?

Stuart

I think you are out of luck... the number of votes is stored in the table but i did not see a detail of who voted how...

Yes, that's right. The DNN Survey module is like a lot of standard survey apps, in that it collects aggregate data and presents it, meaning only the results of votes cast are stored and presented. Sounds like what you really want is a 'voting' application, not a survey app.

Next time try the Nsurvey module from http://www.nsurvey.org .

It isn't that I want to know who voted for who, but rather, who voted. Does that make sense? I just want the number of people who participated in the voting process.

I saw nsurvey too late to grab a hold of it. I had already demoed the project. Next time...

Stuart

Do you want the number of people that voted, or specifically WHO voted. Those are 2 different things...

I want to know WHO voted.

Stuart

The number of people who voted could be tallied by adding up the total votes... I think he is wanting WHO voted. i don't see any way to retrieve that information from the current layout.

There is no built in way to determine who voted. You can add to the module and make that happen. For this to work, however, the survey would have to of used Personalization. You would have to do a select query with a join on the Users table on UserID. You would have to pass in the moduleID and select the ones with the SettingName in the code.

If you are interested in going further, I will dig up more information which you would need.

See, just so you don't think I'm crazy, this is the sentence by Stuart that confused me:

"I just want the number of people who participated in the voting process. "

Obviously, he doesn't just want the number, he want to know "who" (as he had said in the sentence previous to this one). I just wanted clarification.

Matt

YOUR CRAZY :)

Nah... I did a lot of things yesterday. I am not a great writer of information.

Stuart