[Theforum] Changes to the VotingReqs document

.jeff jeff at members.evolt.org
Tue Feb 5 02:53:07 CST 2002


> From: Elfur Logadottir
> no. i'm suggesting having two tables, that much you've
> got right.


> the 'main' table stores result and *all* things related
> to it (including the userID) the other table is used
> *only* when the voting type is anonymous and then it
> *only* stores questionID and userID. this way we have
> the normal 'change your vote' thing, but have the
> possibility to use anonymous voting.

no, ick.  i hate the idea of having results stored in a smattering of
tables.  i hate the idea of having to decide just prior to display of the
results which table i'm going to be querying to get those results.  i hate
the idea of having to know whether the vote is "anonymous" or not before
choosing which table to insert the user's selection into.

what's more, the scenario you describe doesn't allow us to restrict users
from voting more than once -- something that storing the userid accomplishes
quite nicely.

i think the integrity of the vote (ie, making sure there's only one vote per
person) is far more important than the notion of anonymity.



jeff at members.evolt.org

More information about the theforum mailing list