Welcome to My Blog a one stop shop for all of my day to day ramblings and technical problems and solutions. I generally try and post useful snippets of code and issues that I have experienced in my day to day work, but also any topics that might be of interest to the wider technical community and in particular the Adobe community. I hope you find it useful.
My Latest Posts
Adobe ColdFusion 10 - What's new and what can we expect from an upgrade?
ColdFusion 10 is the new application development server due for release this year by Adobe. What's new in the server offering and is it worth a upgrading? Read more ...
Automating Database Backup for Microsoft SQL 2005 Express
If you are running a Microsoft SQL 2005 Express edition database and want to automate a daily backup of your database data, then this handy script can help you automate this task and protect your data files. Read more ...
SQL Concatenation - Get column values as comma seperated list using XML PATH() instead of UDF's using SQL COALESCE
A handy T-SQL technique for getting column values as comma seperated list using XML PATH() instead of UDF's using COALESCE Read more ...
What are the Google Web Font(s) API and the Google Font Directory?
The Google Font API helps you add web fonts to any web page. Benefits of the Google Font API include: A choice of high quality open source fonts. Works in most browsers. Extremely easy to use. Read more ...
Problem passing + parameter to jQuery Uploadify
I have battled with a problem today using jQuery uploadify on a project I am currently working on. For some reason my string parameter was being stripped of the '+' characters. Read more ...
onRequestStart - variables scope
A nice little gotcha that I came across today whilst defining a new application.cfc. Within my onRequestStart method. Read more ...
ColdFusion Development and Consultancy in the UK
Just a quick reminder that I can offer Adobe ColdFusion consultancy and development to UK and EU businesses. Read more ...
Adobe AIR 2.0 is released on BETA
Adobe have released version 2 of the AIR cross platform runtime, that builds on the success of AIR 1 giving developers new capabilities. Read more ...
Flash and AIR on the iPhone
Yes you have read this right ….. Adobe Flash CS5 will allow developers to create applications built using Actionscript 3, available for the iPhone and iPod touch. Read more ...
Setting Equal Heights using JQuery
I recently ran into a problem of trying to align the height of 2 columns (col-left and col-right) and ended up using a JQuery plugin for the solution. Read more ...
Adobe Flex 4 SDK
Adobe have made available the BETA release of the Flex 4 SDK (previously codenamed Gumbo) Read more ...
Import CSV data into Microsoft SQL 2005 using bulk insert
A little problem I had recently was to import a CSV file with about 16mb of data, into a Microsoft SQL 2005 database, using Microsoft SQL Studio Express. Read more ...
You do not have permission to use the bulk load statement
I had a problem when trying to bulk load a CSV file into my Microsoft SQL 2005 database. The error was "You do not have permission to use the bulk load statement". Read more ...
JQuery – A Web Developer’s Best Friend!
I haven’t posted on my blog for a while now as it’s been a little hectic on the work front. I did however feel it necessary to post something about this superb javascript framework called JQuery. Read more ...
Building iPhone Applications
I have been looking into developing some sample applications for Apple’s iPhone. I discovered a very nice example application that was written by a colleague of mine from TAG Worldwide. Read more ...
SQL Get Distance from Longitude and Latitude
I am currently building a mileage and distance calculator for one of my clients and needed a solution to calculate the distnace between 2 geocoded longitude and latitude points. Read more ...
SET IDENTITY INSERT Microsoft SQL Server
Just a quick helper for anybody looking to create a table on Microsoft SQL Server, using TSQL. When setting up a table with an IDENTITY column. Read more ...
Alter a table that is published under SQL 2005 replication
Having recently implemented Microsoft SQL 2005 replication for a client, we had a few issues with developers trying to alter schema on the database if the table is under replication. Read more ...
Microsoft SQL 2005 find tables missing primary keys
I recently setup replication for Microsoft SQL 2005 server for a client and needed to provide a list of tables to the client without primary keys, as these are not transferred in the replication. Read more ...
File Upload with Flex and Coldfusion
I am currently working on a sample Flex application that requires the ability to upload files to a destination server. Read more ...