New Coding 4 Fun Article up...- July 28, 2004 Add a Quick Poll to Your Web SiteSummary: Duncan Mackenzie describes his process to build a "Quick Poll" using Visual Basic and ASP.NET.Recent discussions have motivated me to add some 'anti-repeat-voting' code to this sample... I've finished up most of the changes, so grab the sample from the article if you are interested and then watch this space for more information on the additions!http://blogs.msdn.com/duncanma/archive/2004/07/28/200228.aspx With things like AOL and other proxies... how useful is IP Address in figuring out duplicate votescommentsetc...- July 27, 2004 I'm playing around with my voting control and I was thinking of (in addition to a cookie based check) querying to see how recently this IP address had tried voting and if it was within 'x' seconds, rejecting the vote... Something more extreme, like rejecting any second vote from the same IP seems wrong, since multiple people could be coming in through the same IP.. in fact, you have to assume that is likely over time... What do you folks think Is a time-limit per IP address reasonable, or.http://blogs.msdn.com/duncanma/archive/2004/07/27/199214.aspx I'm thinking of adding loginregistration to my personal site...- July 26, 2004 Not sure what scenarios this will be used to enable in the long run, but I might play around with some web services (with authentication) and a few 'prototypes' for articles and MSDN features that I've been musing about... Do you run a personal siteDo you have any form of authenticationWhat do you use to handle it (I'm planning Forms Authentication against SQL Server)What do you use it forthis is for http:www.duncanmackenzie.net ... which is quickly becoming my little sandbox for asp.net...http://blogs.msdn.com/duncanma/archive/2004/07/26/197731.aspx Don't ask me why, but I've become the official forum for Spiderman 2- July 21, 2004 I blame google.(250 + comments so far, not counting the ones I've had to remove)http://blogs.msdn.com/duncanma/archive/2004/07/21/190088.aspx Default Values, Triggers, and Code supplied values ... oh my!- July 14, 2004 In an earlier post, I mentioned that I use a trigger to update a "DateCreated" field in one of my tables... and various people commented on this... asking "why not pass in a value in your Insert" or "why not use a default value"Since I feel that replying to comments in the comments section is generally just a black hole, I thought I'd raise this discussion up to a proper blog entry of its own :)I tend to have audit information on my tables, and that often includes 4 columns; DateCreated,...http://blogs.msdn.com/duncanma/archive/2004/07/14/183219.aspx New Poll is up and a silly mistake...- July 10, 2004 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 &8220;On Insert&8221; trigger to set that column to the current datetime.... 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 datetime info. Yeesh. Oh well, not a big deal since I'm still in the...http://blogs.msdn.com/duncanma/archive/2004/07/10/179605.aspx |