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
Microsoft SQL Server TSQL Random Rows and Records using NEWID()
If you are looking to return random rows or records using Microsoft SQL Server (TSQL), then this handy function will help you with just that. NEWID() Read more ...
cfdocumentitem footer and variables scoping - attributes scope
When using cfdocumentitem inside a cfdocument tag, I had problems accessing variables set outside in other scopes including session, application, local and specifically in FW/1 the rc scope. Well attributes scope to the rescue Read more ...
LOCAL scoped variables and Query of Query conflict syntax error
A small problem when using LOCAL scoped variables in ColdFusion, that you then need to use in a Query of Query (QofQ). Query of Queries Syntax error encountered "LOCAL" Read more ...
sp_generate_inserts - A handy SQL stored procedure for generating insert statements
Sometimes scripting your database data can be a real headache for promotion to a live environment. This handy SQL stored procedure (proc) called sp_generate_inserts can help you generate your SQL insert statements. Read more ...
Product and Software Release Management - Microsoft SQL and ColdFusion - Your Thoughts?
When managing or developing software, there will become a time that the product goes live online. After that time how do you manage your product and software release management for SQL and ColdFusion? Read more ...
Capitalize the first letter in every word using ColdFusion | Regex to the rescue
I just recently required a snippet of code to capitalize (uppercase) the first letter of each word in a string, using ColdFusion, before returning back to the screen for output. Regex (Regular Expresssion) to the rescue. Read more ...
Open BlueDragon (OpenBD) 1.4 bundled with Tomcat 6 - Support SES URLs - Update web.xml
I am currently running an Open BlueDragon (OpenBD) install on my local development mnachine, that is bundled with Tomcat 6.0. This little tip should help anyone looking to run SES URLs (e.g. /index.cfm/*). Read more ...
How to issue a Trackback using Adobe ColdFusion and CFHTTP
I've been meaning to get round to having the ability to issue Trackbacks and Pings using my custom built CMS, but also provide my site with the ability to receive Trackbacks and display them for genuine comments and credits. Read more ...
Wordpress Websites - Easy to install, configure, administer .... BUT
I love Wordpress. It's a great tool for quickly building websites, blogs and some great looking sites .... BUT it seems to make website design and development TOO EASY and leads to the birth of "overnight" web designers and web developers. Read more ...
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 ...