I have a voting poll and 5 options for yes no or abstain.
db is simple for now, 5 rows each with fields
id, choice1=yes, choice2=no, choice3=abstain and vote1 vote2 vote3
catching the counts for each.
I want to user only have one for for each row.. lets say each topic is
topic1, topic2.. etc to topic5
I can catch LOCAL_ADDR coming in but i need to validate if they have voted already on each topic..
i have so far...
<code>
If LOCAL_ADDR <> Session("LOCAL_ADDR") then
rsPoll.Fields("votes" & iVote).Value = rsPoll.Fields("votes" & iVote).Value + 1
rsPoll.Update
' Set Flag to prevent revoting
Session("LOCAL_ADDR") = LOCAL_ADDR
End If
</code>
db is simple for now, 5 rows each with fields
id, choice1=yes, choice2=no, choice3=abstain and vote1 vote2 vote3
catching the counts for each.
I want to user only have one for for each row.. lets say each topic is
topic1, topic2.. etc to topic5
I can catch LOCAL_ADDR coming in but i need to validate if they have voted already on each topic..
i have so far...
<code>
If LOCAL_ADDR <> Session("LOCAL_ADDR") then
rsPoll.Fields("votes" & iVote).Value = rsPoll.Fields("votes" & iVote).Value + 1
rsPoll.Update
' Set Flag to prevent revoting
Session("LOCAL_ADDR") = LOCAL_ADDR
End If
</code>