Ok it seems to be saying to you that the settings in the Open Bluedragon admin console are preventing this from being executed.
Is there an option under the datasource advanced properties that looks like it needs ticking/unticking ? If not wrap the logic up as a stored procedure and try calling that Cheers A On 5 March 2012 12:54, Lee <[email protected]> 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 > -- Alex Skinner Managing Director Pixl8 Interactive Tel: +448452600726 Email: [email protected] Web: pixl8.co.uk -- online documentation: http://openbd.org/manual/ google+ hints/tips: https://plus.google.com/115990347459711259462 http://groups.google.com/group/openbd?hl=en
