On my local development machine I have Coldfusion 10. Recently I needed to install MySql so I downloaded the latest version and installed it. I was able to successfully setup a datasource but when I tried to use it I got 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'
Some quick googling showed me that it was a problem with the database driver in cf. There were some articles about updating the driver manually but they were kind of old. I decided to update cf first and see if that helped. I had not installed any updates yet on my local machine. I updated to update 13 and everything started working so it was an easy fix this time.
Subscribe to:
Post Comments (Atom)
Coding
I'm not sure where I heard this, and it wasn't worded this way, but it helps to think about coding this way. Basically, any progra...

-
I continued working on my 2d project today. I was able to get some other npc characters to animate. I added one of the pre-made killzone o...
-
Some Android applications use space on your Google Drive to store data. You can't see this data by browsing drive the normal way. You ...
-
A few days ago I read about the trolley problem. It was mentioned in an smbc-comics.com comic. I hadn't heard of this before, but I ha...
No comments:
Post a Comment