Since we went through and geocoded all of the Australian postcodes and suburbs we have found ourselves finding all sorts of uses for it, and have been madly going through projects and using this data. We have the data in our master code database, and in order to make use of it in a clients […]
We recently had to work out how to display a random quote from a table in the database. Clearly we could have created a random number with CF and then simply retrieved that row or id from the database, but what if the rows didn’t have consecutive ID’s? We came up with this solution in […]
We just went live with 6 months worth of work and it has been really smooth considering the amount of changes. Aside from the stupid questions from userland we haven’t had any major issues. We did however experience some slow downs which we could attribute only to the AJAX suggester tools we had implemented in […]
We started to use Database servers on our local machines at work recently and we decided to go with SQL 2005. The production and development servers we have are all SQL 2000. Being workstations and laptops we decided that SQL Express would be the most appropriate version for the machines as it is stripped down […]
