Matt, Some queries work fine. Try this one,
> <cfquery datasource="mpds" name="qGet"> > SHOW FULL Tables > </cfquery> > <cfdump var="#qGet#"> Charlie On Mar 6, 2011, at 1:27 PM, Matthew Woodward wrote: > On Sun, Mar 6, 2011 at 12:31 PM, Skellington <[email protected]> wrote: > Matt, thank you very much... > > Yes, I was using the default driver from the OpenBD war files ( 5.1.12 > i think ) and then I also swapped it out for the 5.1.15 and still had > the same result. > > I can't replicate the problem. > > Fresh install of MySQL 5.5 on a Windows VM. > > Fresh download of OpenBD Ready2Run version 1.4, using the default MySQL > drivers that ship with OpenBD 1.4. > > Created a test database in MySQL with a user table with fields id, > first_name, and last_name. > > Ran this query: > <cfquery name="test" datasource="test"> > SELECT * FROM user > </cfquery> > > Runs fine and a dump shows the correct data. > > When I created the datasource in OpenBD I accepted all the default settings > for MySQL datasources, meaning that cache resultset metadata is *unchecked*. > > -- > 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
