A fast way to delete orphaned records
A fast way to delete orphaned records in MySQL Read more »
Using SET DATEFORMAT with MS SQL Server
I just wrote a stored procedure for Microsoft SQL Server which creates a report for the previous month. However, for certain months MS SQL Server was assuming the date was formatted as yyyy-dd-mm instead of yyyy-mm-dd. In turns out that you can set the dateformat and avoid these issues by using SET DATEFORMAT Read more »
ORM and the Nested Set Model
Using hibernate ORM's HQL with the Nested Set Model for storing hierarchical data. Read more »
Getting started with HQL
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
Just a quick post about using queries in cfscript with named parameters. Read more »
Replicating MySQL's LIMIT clause in ColdFusion
Replicating MySQL's LIMIT clause in ColdFusion Read more »
Scheduled MSSQL Express Backup
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
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
A little quick start guide I've put together for Transfer ORM Read more »
Installing SQL Server 2008 Express
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 »
Search
Wish List
Found something helpful & want to say ’thanks‘? Then visit my Amazon Wish List :)
Categories
- ANT (1)
- Apache (9)
- CFBuilder (2)
- CFEclipse (6)
- cfspec (2)
- Coldbox (20)
- ColdFusion (263)
- ColdFusion on Wheels (4)
- Coldspring (10)
- DevonCFUG (18)
- EXT JS (1)
- Flex (7)
- Fusebox (27)
- FW/1 (5)
- Hibernate (29)
- IIS (2)
- jQuery (32)
- Lightwire (3)
- Linux (1)
- Off Topic (12)
- OOP (33)
- Publications (1)
- Railo (6)
- Resources (21)
- Reviews (9)
- RoR (1)
- SOTR (4)
- SQL (31)
- Subversion (9)
- TDD (4)
- TortoiseSVN (3)
- Transfer (10)
- ValidateThis (7)
- Windows (1)
- All Categories
Recent Posts
- Handling null db values with ORM
- ColdBox Object Cache Manager occasional error
- If ColdFusion is old then what about these...
- I'm speaking at cf.Objective() 2012!
- ColdFusion v Railo ORM
- ColdFusion, Railo & JSON
- Using Slice() in ColdFusion
- Running the same Code on ColdFusion & Railo
- Loading slideshow images on demand
- jQuery mouseover expanding menu