I get a red X in eclipse because of the unescaped " before the last FROM.
On Nov 14, 2011, at 4:34 PM, Gino Pacitti wrote: > Hi All > Any help with this code: > > I am trying to execute this code: > > EOEditingContext ec = new EOEditingContext(); > > ERXEOAccessUtilities.evaluateSQLWithEntityNamed(ec, "Sitedata", "SELECT > 'resourceName','address','place' UNION SELECT resourceName,address,place INTO > OUTFILE '/Users/Gino/Desktop/salesreport.csv' FIELDS TERMINATED BY ',' > OPTIONALLY ENCLOSED BY '"' FROM Sitedata;"); > > And I get this exception? > > Any help or experience.. > > Access denied for user 'admin'@'127.0.0.1' (using password: YES)at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928) > at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571) > at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666) > at com.mysql.jdbc.Connection.execSQL(Connection.java:2988) > at com.mysql.jdbc.Connection.execSQL(Connection.java:2917) > at com.mysql.jdbc.Statement.execute(Statement.java:529) > at > com.webobjects.jdbcadaptor.JDBCChannel._bindInputVariablesWithBindingsAndExecute(JDBCChannel.java:272) > at > com.webobjects.jdbcadaptor.JDBCChannel._evaluateExpression(JDBCChannel.java:337) > at > com.webobjects.jdbcadaptor.JDBCChannel.evaluateExpression(JDBCChannel.java:296) > at > er.extensions.ERXEOAccessUtilities.evaluateSQLWithEntity(ERXEOAccessUtilities.java:191) > at > er.extensions.ERXEOAccessUtilities.evaluateSQLWithEntityNamed(ERXEOAccessUtilities.java:164) > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/rgurley%40smarthealth.com > > This email sent to [email protected] _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
