mysql query error

[rohan rehman]

<cfquery name="results" datasource="urbanfiles" dbtype="JDBC">
SELECT combobox
FROM cb_items
</cfquery>


the status is Ok when I verify all connections in CFMX7 I installed hte JDBC
driver for Mysql 4.1

but when I query it i get this error in the log

Error Executing Database Query.

I attempted the exact same method with an access db and dbtype="ODBC" and it
was fine.

is there something I need to add when querying a mysql db?

[mxstu]

What is the complete error message? Which log file?

[rohan rehman]

ohh thanks for the reply.

in the flash.log since I am remoting.

is there anywhere else I can look for more info?

[mxstu]

I'm familiar with remoting so I can't help you with that part. As far as the error, what is the full error message? It should say something more than " Error Executing Database Query." ?

[rohan rehman]

haha human error

SELECT cb_items
FROM combobox


not

SELECT combobox
FROM cb_items

[mxstu]

Completely unacceptible ;-) MM will be calling shortly to take back your copy of Flash.