One of the big reasons I redesigned the poll component, was so that I could track votes over time… I did this by adding a ‘dateVoted’ column to my vote table, and then using an “On Insert” trigger to set that column to the current date/time…. peachy keen, except when I exported the tables and stored procs to my live SQL box, I forgot to include my triggers… so all the votes on my previous poll have no date/time info. Yeesh. Oh well, not a big deal since I’m still in the testing/building stage, but still a very silly mistake.
Thoughts on this post? Feel free to reach out on Twitter!
2004-07-11 00:50 +0000
e06898f @ 2019-03-31