jQuery - Getting Started
June 26, 2008
I recently did a presentation on jQuery for the Devon ColdFusion User Group. If anyone is interested I have put the slides on the Devon CFUG web site. Download the sample files Note: to view the presentation in full screen, click the arrow in the top right hand corner. Read more »
Using Identity insert
June 26, 2008
I was looking at Todd Sharp's getGeneratedKey function on UDFLib, which returns the identity (auto generated primary key) when you insert data into a database. It works by making use of the result attribute of cfquery, that was introduced in ColdFusion 8. This lead me to think about what ColdFusion was doing under the hood and how you could do it with older versions of ColdFusion. Read more »
Remove circuit.xml.cfm from Model and View circuits
June 25, 2008
I recently did a talk on Fusebox 5.5 at Devon CFUG and mentioned that you get rid of all those pesky circuit.xml.cfm files from the Model and View directories, and found that it isn't widely known that you can do this. Read more »
Search for % sign in SQL.
June 25, 2008
MS SQL server uses the percentage sign (%) as a wildcard when you use the like operator. So what if you want to search for the percentage sign? Read more »
My DAO/Gateway hybrid
June 19, 2008
As a spin off of my post An ORM sceptic a few people have asked me how I handle my database interaction. So here it is... Read more »
Reload Fusebox in IE, Safari and Firefox
June 19, 2008
If you want to reload Fusebox in IE, Safari and Firefox then you can use a bookmarklet to do it. Read more »
Extract Time from DateTime field
June 16, 2008
I had a problem in MS SQL Server, where I need to do some calculations on the time part of a datetime field, to see how many people had arrived late for the job they were booked for. Normally I'd use the DATEDIFF function in SQL Server. For example: … Read more »
Rebooting ColdFusion server nightmare
June 15, 2008
I recently came across an "interesting problem" (by which I mean nightmare) when rebooting a ColdFusion server. The server hosts approximately 30 web applications, all of which use a framework (mostly Fusebox). The issue I had was that the … Read more »
New ColdFusion Podcast
June 13, 2008
Brian Meloche has started up a new podcast for the ColdFusion community over at CFConversations. The first edition should be available from Sunday. To quote the site: "We are planning to make this a combination of an interview and a roundta… Read more »
Use jQuery to make external links open in a new window
June 11, 2008
I was just reading the comments of Raymond Camdens post about the best way to trim text and saw that someone was asking how to add target="_blank" to all external links. Now this can be done in ColdFusion using the CFMatch tag (a great addi… Read more »