We ran into a problem recently when trying to upgrade our system to use MySQL 5.6. We're running ColdFusion 9 Enterpise with the MySQL JDBC drivers that ship with CF9 and CF10 and as soon as we swicthed our testing environments over to MySQL 5.6 everything blew up.
What we found is that the MySQL team has finally removed support for a long depricated function, a function all of the legacy JDBC drivers are still using.
The MySQL drivers that ship with CF 9 and CF 10 are, 5.1.11 and 5.1.17 respectively. Anything older than 5.1.22 when combined with MySQL 5.6 will produce the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL_SELECT_LIMIT=DEFAULT' at line 1
To correct the issue you need to go download the latest MySQL JDBC driver, at the very least 5.1.22 or greater. Please keep in mind, while this is a pretty safe thing to do, Adobe's offical position is that they do not support any MySQL version greater than 5.1
Pete Frietag (http://www.petefreitag.com) has logged a bug with Adobe - help us get it fixed by up voting the issue so they'll include the latest driver with th enext patch
More nerdy details on the issue can be found here:
Posted by Alan Rother in Mobile Development on July 2, 2012
Just wanted to save this and share, I'm doing some mobile development at work and I found a great Firefox plugin that let's me fake out my location. It's called GeoLocator (https://addons.mozilla.org/en-US/firefox/addon/geolocater/)
It's pretty awsome for early testing on location aware HTML apps.
Posted by Alan Rother in Random Ideas on June 26, 2012
I have an idea for a new tool on the site (seriously - no sarcasm)
You already have a way to "suggest friends" to our existing friends, but that only makes sense if the two people know each other already. I have a situation where I know two people, but they've never met and no nothing about one another. If I simply "suggest" one of them to the other, they won't know why. You don't give us any opportunity to send a message along with the suggestion.
I propose a new feature, similar to "Suggest" called "Introduce"
It would allow you to connect one or more existing friends to one another along with a message explaining why you'd want to "friend" this new person. It could have a myraid of uses, introducing people from a dating perspective (hey Tom, you should meet Mary, she's awesome), bringing people into niche groups or folks with common social hobbies or interests and even businesses who have a FaceBook presence could use this a way of introducing the existing team to new employees.
So this one is mostly for me so I don't forget this in 6 months when I need it again.
ColdFuson does so much for us, but sometimes it tries to do too much and leaves you hanging. I had a simple object, essentially an appointment, which included a date time value retrieved from a MySQL databse. When I called the service method from ColdFusion, it's returned a standard CF date object to me that I could easily parse, but when I pulled the same object via jQuery(ajax / JSON) ColdFusion parsed the date object into a string like this:
June, 28 2012 20:00:00
Needless to say, the jQuery date formatting plugin I am using refused to parse it. My awesome co-worker Travis quickly pointed out that simply hitting the value with Date.parse(myDateString) would solve my problem.