If you're using MySQL version 5.6 you may get 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'
The fix is to upgrade your MySQL driver in Coldfusion. Charlie Arehart has a great post on how to fix it. http://www.carehart.org/blog/client/index.cfm/2013/4/24/solving_seeming_CF_MySQL_5.6_incompatibility
