All ticked in OpenBD admin for the datasource, will give the SP a go after lunch.
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
