Hi Matt, Cannot appear to do single alter statements on their own etc so looks like only SELECT, UPDATE, INSERT and DELETE currently work without any issues.
I am just waiting for my mate who helped configure mySQL in the first place to wake up and let me have the root password to try that account. Will report back. Just seems strange that I can complete the actions if I am logged into the box through SSH as root and then log into mysql at the prompt with the user that OpenBD is configured to use. Regards, Lee On Monday, March 5, 2012 12:54:34 PM UTC, Lee wrote: > > Afternoon All, > > Having been able to get passed the initial hurdle of using CFexecute to > extract my .gz files (Thanks Nitai!!). I have kit my next snag. I am trying > to load the data directly into the table from the file using this command. > > LOAD DATA LOCAL INFILE '/usr/share/tomcat6/webapps/ROOT/bestdeals.txt' > INTO TABLE BestDeals FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' > (DealID, DealType); > > If I run this command directly from SSH logged in a the same used I have > the datasource configured to use in OpenBD I have no problem and the data > hops on in happily. > > If I run a query as follows: > > <cfquery datasource="m4e" name="FileUpdateAudit"> > LOAD DATA LOCAL INFILE '/usr/share/tomcat6/webapps/ROOT/bestdeals.txt' > INTO TABLE BestDeals FIELDS TERMINATED BY 'r' (DealID, DealType) > </cfquery> > > I get an error as follows: > > SQL operation disabled via admin console > > Any thoughts? > > Regards, > > Lee > -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
