[Theforum] Changes to the VotingReqs document

Elfur Logadottir elfur at elfur.is
Tue Feb 5 15:41:00 CST 2002


From: ".jeff" <jeff at members.evolt.org>

|  take a minute to go read one of my first reply's to you in this thread.
| you'll see that's exactly what i proposed to you.  i still don't like it
| though.

well, you not liking it is not compelling argument :) i don't necessarily
like it, but think it's important anyways.

| but you're missing the point.  as long as we have to ensure the integrity
of
| the vote (ie, each user can only vote once), then there's no chance of
100%
| anonymity.

[snipping some compelling argument]

| let me give you an example:
|
| SELECT *
|   FROM results
|  WHERE voteid = 1
|  ORDER BY resultsid

[...]

| SELECT *
|   FROM anonresults
|  WHERE voteid = 1
|  ORDER BY anonresultsid
|
| ANONRESULTSID  VOTEID  QUESTIONID  USERID

what happens if there is no anonresultsID ??
can't the table be automatically ordered by userID?

doesn't that mean, that when i request the data from the table, i get them
ordered by userID and if there is no anonresultsID there is no guaranteed
way of putting them in the order they were casted

thanks
*the persistent one*




More information about the theforum mailing list