MySQL Archive

  • Setting Database Connections in JBoss/ ATG

    Setting Database Connections in JBoss/ ATG

    ATG 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...

    Project info

  • Google Maps API part 2: Retrieving Postcodes from your database

    Google Maps API part 2: Retrieving Postcodes from your database

    OK, 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...

    Project info

  • Joining columns/ concatenate strings in Oracle PLSQL/ MySQL

    Joining columns/ concatenate strings in Oracle PLSQL/ MySQL

    Joining 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...

    Project info

  • Google Maps API part 1: Accurate Geocoding for UK Postcodes

    Google Maps API part 1: Accurate Geocoding for UK Postcodes

    Recently 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...

    Project info

  • Using Javascript/ AJAX to post HTML form data

    Using Javascript/ AJAX to post HTML form data

    Why 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...

    Project info

  • Creating XML from PHP/ MySQL for use with SPRY

    Creating XML from PHP/ MySQL for use with SPRY

    So 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...

    Project info