Did you try to use SHOW VARIABLES LIKE '%version%' ? Use the ' instead of the ". This is proper SQL actually….
On Thu, Jan 24, 2013 at 3:31 PM, Skellington <[email protected]> wrote: > Hmm weird, I downloaded the Nightly build of the Ready2Run, logged in to the > admin created the MySQL datasource. I then created a db.cfm file with the > exact code below, and it's broken. If I use Navicat and connect to the > database with the same account and run the query, it works fine. > > <cfquery name="gGetDBInfo" datasource="mpds"> > SHOW VARIABLES LIKE "%version%" > </cfquery> > <cfdump var="#gGetDBInfo#"> > > Thanks, > Charlie > > > On Thursday, January 24, 2013 1:25:21 PM UTC-8, Nitai @ Razuna wrote: >> >> On Thu, Jan 24, 2013 at 3:20 PM, Skellington <[email protected]> wrote: >> > I just verified that this is also broken on the Nightly release. >> >> >> Strange, it works here. Are you sure there is nothing else in your >> template/code that would break it? >> >> Kind Regards, >> Nitai >> >> -- >> See for yourself how easy it is to manage files today. Join the >> revolution! >> >> Razuna - Hosted Digital Asset Management Solution >> http://www.razuna.com/ >> >> Razuna - Open Source Digital Asset Management >> http://www.razuna.org/ >> >> Twitter - http://twitter.com/razunahq >> Facebook - http://www.facebook.com/razunahq >> Support Platform - http://getsatisfaction.com/razuna > > -- > -- > online documentation: http://openbd.org/manual/ > http://groups.google.com/group/openbd?hl=en > > > -- See for yourself how easy it is to manage files today. Join the revolution! Razuna - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Twitter - http://twitter.com/razunahq Facebook - http://www.facebook.com/razunahq Support Platform - http://getsatisfaction.com/razuna -- -- online documentation: http://openbd.org/manual/ http://groups.google.com/group/openbd?hl=en
