I ran into a problem this afternoon with cfqueryparam when querying an Oracle database that really had me scratching my head. In my query's WHERE clause I was filtering against a column that had a CHAR(8) datatype, but whenever I ran the query with cfqueryparam it wouldn't return any results.

More »

Probably one of the most useless database errors I have ever come across (besides the "Catastrophic Failure" I sometimes seem to generate in SQL Server), is "The MySQL Server Has Gone Away".

Really? Where did it go? Is it coming back anytime soon, because I've got work to do.

More »