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

Read More

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

Read More

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

Read More

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

Read More

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

Read More

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

Read More