-
Follow me on Twitter
- @MikeMc68 they should be banned, same as the people who stand in the exit rather than stepping off, blocking people from getting offSeptember 3, 2010 12:31
- My hearing is still fecked from riding the Deaf Machine 3 days ago... its a stupid deathtrap of a bike but very very fun...September 3, 2010 8:24
- built a bridge rectifier for my AC generatorSeptember 2, 2010 9:24
- @mike_1727 with a pint of ale in each hand, progressively lightening themSeptember 2, 2010 8:09
- Just ran another 7km - 2 days in a row... will switch routines and exercise down the pub tomorrowSeptember 2, 2010 7:54
MySQL Archive
-
Setting Database Connections in JBoss/ ATG
Posted on December 12, 2009 | No CommentsATG communicates to a database via JBoss via a dynamo server setup or in your home/localconfig directory if you’re not using specific dynamo servers. In this setup you specify the JNDI connection name which will then refer to an XML file which makes up part... -
Google Maps API part 2: Retrieving Postcodes from your database
Posted on September 15, 2009 | No CommentsOK, this is a simple way to get your postcode/ address location returned and displayed via the Google Maps API on your own website. I’ll cover the ‘nearest store locator’ scenario in another post where you want places with a certain radius of an inputted... -
Joining columns/ concatenate strings in Oracle PLSQL/ MySQL
Posted on August 7, 2009 | 1 CommentJoining columns and results together is really easy in Oracle or MySQL, in both there is the same function – CONCAT(). However you should be aware that there are differences between the databases on how this function works. In MySQL the CONCAT() function works by... -
Google Maps API part 1: Accurate Geocoding for UK Postcodes
Posted on July 3, 2009 | 14 CommentsRecently I had to build a system that would take an address, pass it to google and return latitude and longitude values. The result is then stored for later use and display on Google maps. However, firstly I found that the default XML geocoding service... -
Using Javascript/ AJAX to post HTML form data
Posted on June 11, 2009 | No CommentsWhy would you need to do this? Well for instance if you were using 3rd party AJAX APIs and you wanted to capture the data from them perhaps, or maybe you just have a complex form. Or you could use this for form validation to... -
Creating XML from PHP/ MySQL for use with SPRY
Posted on June 3, 2009 | 3 CommentsSo lets say for example you have a table in your database and you want to return some results, pretty easy with PHP/ MySQL and I dare say easy enough with other languages. Now rather than return the results to the page and format them...