Problem with cfqueryparam and Oracle's char datatype.

{ Posted By : Eric Cobb on January 8, 2010 }
752 Views
Related Categories: Databases, CFML

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 »

Elvis has left the building! (or so MySQL says...)

{ Posted By : Eric Cobb on June 3, 2009 }
694 Views
Related Categories: Databases

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 »