On Sun, Mar 6, 2011 at 1:53 PM, Charles Heizer <[email protected]> wrote:
> Matt, > Some queries work fine. > > Try this one, > > > <cfquery datasource="mpds" name="qGet"> > > SHOW FULL Tables > > </cfquery> > > <cfdump var="#qGet#"> > OK, so that query doesn't work for me. Just so I'm not chasing my tail, has this ever worked on any CFML engine? Meaning are you porting things over from Adobe CF and it worked there but not in OpenBD? Ultimately this is a MySQL / driver issue that I think you're going to have to pursue on the MySQL side of things. This does work fine on a nightly of OpenBD against MySQL 5.1.49 in my testing, and there have been a lot of bugs logged with MySQL related to this specific type of operation over JDBC in the past, so I'm not sure there's much we can do. Remember that all cfquery does is pass the SQL statement to the database over JDBC. There's really no more magic to it than that, so I suspect if you ran this query over plain JDBC (which I can test later today, just not right this minute) it would fail as well. To put it another way this query might work fine directly in the MySQL console, but I bet it fails over JDBC no matter how you run it. -- Matthew Woodward [email protected] http://blog.mattwoodward.com identi.ca / Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
