This works just fine with OpenBD 1.3,1.4 and MySQL 5.0.x. I really thought this was a OpenBD issue since this works fine with Railo (I downloaded it just to test), since I wanted to test another engine. If this is a MySQL JDBC issue is there any debug data I can turn on to help file a bug, I've never filed a MySQL bug so I just want to make sure to get as much data in as possible.
Thanks, Charlie On Mar 6, 2011, at 2:12 PM, Matthew Woodward wrote: > 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 -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
