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, if you have the need to insert exisiting data into your new table, you must be familiar with the SET INDENTIY_INSERT [table] ON / OFF statement. One thing to note: [...]

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. The issue is caused because the Microsoft Visual GUI tools for SQL 2005, tries to drop and recreate the table, which is obviously not acceptable [...]

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. This script came in very handy so thought I would share. SELECT c.name, b.name FROM sys.tables b INNER JOIN sys.schemas c [...]

I am currently working on a sample Flex application that requires the ability to upload files to a destination server. I found this article on the Adobe website, by Ryan Favro. It’s a really nice simple example of how to achieve file uploads using Flex and ColdFusion. Multiple File Upload with Flex and Coldfusion

If you are currently restructuring your website to become more “search engine friendly” here is a nice piece of code using ColdFusion, that will also let Google and other search engines know that you have moved your content to a new location and to update their links. Instead of having 404 errors or broken links [...]

It’s probably quite a well documented subject already, but just thought I would shed some light on producing dynamic CSS using ColdFusion. Instead of linking to a static stylesheet in your webiste, you can link to a .cfm template and get ColdFusion to produce the CSS code for you, allowing you to switch graphics, colours, [...]

Wifime has been launched today in the UK, offering low cost wireless mesh networking solutions, for the hospitality and catering industry. Offering an “all in one” easy to setup and install solution, Wifime will allow every hospitality business, the opportunity to offer their guests and customers a wireless internet connection, without the worry of network [...]

This is a really nice demonstration / working app from Adobe. The application is built using Adobe Flex 2 and runs in Adobe AIR. The application has been built to showcase Flex 2′s visual components and the interactivity a Flex application can provide. The application allows small groups to share digital content, exchange ideas, centralise information [...]

The Adobe AIR cross platform runtime is now available for Linux and is available for download from Adobe Labs. This is quite a significant step towards the Adobe AIR runtime working across all three major platforms (Windows, MAC and Linux) and will strengthen the case for the building or rich desktop based apps within Adobe AIR [...]

I ran into an annoying problem today, that was eventually solved by forcing the current processing thread to sleep. The basic task was to stop a windows service on the server, perform some deletions, do some copying, then restart the service. After issuing the <cfexecute> command to stop the service on the server, I would [...]