Related Entries

Interview with Ploners
Formulator makes life easy
Server side python
Resetting Zope's session timeout
Getting undo history

« Rajeev Srinivasan: LTTE, Sangam etc.
» QOTD: Cats and dogs

Simple Poll using MySQL and Zope

Devshed article on making a poll using MySQL and Zope. Simple one. But suffers from the standard database design mistake....

Devshed article on making a poll using MySQL and Zope. Simple one. But suffers from the standard database design mistake.

The author uses a table poll (qid, question, response1, response2, response3, votes1, votes2, votes3). What if some poll has more/less than 3 responses? Better design will be to put it in another table like poll_responses (qid, responseid, response, votes) and join the tables on qid.

  1. ?

    Posted by: Patrickdorning@hotmail.com on March 9, 2004 02:46 AM
//-->