Poll Database Issue

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Bit of a random one...
I was interested to see who voted in a new poll that's been posted in my forum.  So, querying the database I ran:

SELECT     Poll_ID, Author_ID
FROM         dbo.tblPollVote
WHERE     (Poll_ID = '14')

No results.  Hmm, strange.  Double checked that it was indeed poll 14 I was looking at, and that votes had been made in the PollChoice table - 25 in total.

I queried Poll_ID 13, with 10 results pulling back - matching the 10 votes in the PollChoice table.

Tried again on Poll_ID 14, but nothing.

Am I going mad, or isn't it logging the votes against users for some reason?

EDIT - One thing I just noticed is that it's a multiple votes poll, so does this mean it doesn't track who voted for what?  Also, it's a bit odd that people can vote on one option multiple times.  I always though multiple vote polls should just allow you to vote for more than one option, but not one option more than once.