• Categories



  • Archives

  • Archive for the Uncategorized Category


    Converting latitude and longitude coordinates to map x and y values

    Published May 19th, 2009

    I’m currently working on a project to convert an existing Flash map, which uses location data that’s been manually entered and maintained, to use data that comes from a database and uses latitude and longitude values. The original data is stored in an XML file so updating it dynamically is not a problem but as [...]

    MySQL UPDATE with SELECT on the same table in the same query

    Published January 29th, 2009

    I’ve been having a week where there’s a ton of stuff to be done in a short time, yet everything seems to take much longer than it should and every task seems to present multiple unforseen obstacles. 
    Yesterday, for example, I was working on something that had already taken several days of my time when I’d [...]

    Enhanced (‘encouraged’) blog commenting

    Published January 12th, 2009

    Here’s a great blog post discussing a technique to simplify and encourage commenting on a blog, in particular by quoting text snippets. I might well try to find the time to implement it here on StickBlog.