ORM and the Nested Set Model
November 12, 2009
Using hibernate ORM's HQL with the Nested Set Model for storing hierarchical data. Read more »
Getting started with HQL
November 05, 2009
Hibernate has it's only query language called HQL. I thought I'd put together some simple examples of how you can use it in your ColdFusion 9 applications. Read more »
cfquery in cfml with parameters
July 15, 2009
Just a quick post about using queries in cfscript with named parameters. Read more »
Replicating MySQL's LIMIT clause in ColdFusion
June 08, 2009
Replicating MySQL's LIMIT clause in ColdFusion Read more »
Scheduled MSSQL Express Backup
May 07, 2009
Microsoft SQL Server Express is a free slimmed down version of Microsoft SQL Server. One of the features missing from the Express edition is the backup facility, however you can still use the SQL commands. Read more »
"The Definitive Guide to MySQL 5, Third Edition" for $10
January 27, 2009
In case you don't know (or don't check everyday) you may not have spotted that today's $10 ebook from Apress is The Definitive Guide to MySQL 5, Third Edition Read more »
Transfer ORM Cheat Sheet
December 09, 2008
A little quick start guide I've put together for Transfer ORM Read more »
Installing SQL Server 2008 Express
November 12, 2008
Installing SQL Server 2008 Express - you'd think it would be simple, but you'd be wrong! here are the steps you will need to go through (on Windows XP at least!) Read more »
Maximum list values for cfqueryparam
October 22, 2008
I've just managed to get ColdFusion 8 to blow up MS SQL Server 2000! This is the error message I was getting: [Macromedia][SQLServer JDBC Driver] The DBMS returned an unspecified error. The command code was 0. Read more »
Use Subqueries - they are fast!
September 05, 2008
Using SQL subqueries can give your huge performance gain over manipulating recordsets with ColdFusion. Read more »