Not much help. I'm running MySQL version 5.0.51.
Within your bluedragon.xml file, have you checked the <hoststring> node
of your datasource to insure that the URL contains
"cacheResultSetMetadata=false" ?
It seems like the newer 5.5 mySQL engine may have changed what it's
returning. Perhaps this page might help AW estimate possible causes:
http://dev.mysql.com/doc/refman/5.5/en/news-5-5-9.html
Sorry if I'm late to this thread and repeating stuff.
Al
On 2/24/2011 11:01 AM, Skellington wrote:
Hi Alan,
What version of MySQL are you using? My production MySQL DB is 5.0.x
and this works just fine as well. But my development DB is 5.5.9 and
this does not work.
Charlie
On Feb 24, 10:42 am, Alan Holden<[email protected]> wrote:
FWIW - This works on my system:
<cfquery datasource="redacted" name="qTables">
SHOW TABLES
</cfquery>
<cfdump var="#qtables#"><cfabort>
I'm running a Tomcat distro:
Open BlueDragon Product Version 1.4a
Open BlueDragon Build Date 2010-08-07 01:00:38 GMT
Operating System Ubuntu Linux i386 (2.6.24-19-server)
Application Server Apache Tomcat/6.0.20
Java Virtual Machine Sun Microsystems Inc. 1.6.0_17
MySQL 4/5 (MySQL)
Per-Request Connections: no
Cache Result Set Metadata: no
WEB-INF/lib/mysql-connector-java-5.1.12-bin.jar
--
tag/function ref: http://www.openbluedragon.org/manual/
mailing list - http://groups.google.com/group/openbd?hl=en
Get to Texas in Feb for OpenCFSummit http://www.opencfsummit.org/
