I’m in the process of porting an MSSQL databse to MySQL which powers a CFMX 7 application. Some of the query calls were getting hung up when using multiple queries inside one cfquery tag. By default multiple queries are not permitted. After digging around on the mysql site, turns out there are a [...]
I keep forgetting how to do this and then where to find my notes, so I thought I would post it here…easy to find later.
1. Download MySQL Connector/J 3.1.12..
2. Extract this file and find a file named “mysql-connector-java-3.1.12-bin.jar”. Copy this file into “[cfmx_root]/runtime/lib” (this is for windows)
3. Restart the ColdFusion server.
4. Use the [...]
I’d been getting the dreaded , “Application error (Rails) message” for a little while and wasn’t sure what the cause was. After digging around a bit I figured out that it was my own error handler that was causing the error. Pretty ironic, eh? I used some code from AWDR to catch all exceptions, [...]
I’ve been a big fan of MySQL for quite a while, and one of the reasons is its ease and simplicity of use. I’m in the process of migrating a SQL Server database to MySQL and aside from the relief that moving away from SQL Server will bring, I have to mention MySQL’s Migration [...]