Re: Help with ERXEOAccessUtilities

2011-11-17 Thread Kieran Kelleher
As Ramsey pointed out, to compile, this line needs the " escaped in the java string: ERXEOAccessUtilities.evaluateSQLWithEntityNamed(ec, "Sitedata", "SELECT 'resourceName','address','place' UNION SELECT resourceName,address,place INTO OUTFILE '/Users/Gino/Desktop/salesreport.csv' FIELDS TERMINA

Re: Help with ERXEOAccessUtilities

2011-11-17 Thread Henrique Gomes
I really do not know much about mysql security model. Are you sure you have permissions? Have you tried running that statement on the command line client for mysql? Can't really help more than that, sorry. HG On Nov 15, 2011, at 12:08 PM, Gino Pacitti wrote: > But how is that so? > > Other

Re: Help with ERXEOAccessUtilities

2011-11-15 Thread Henrique Gomes
On Nov 14, 2011, at 11:34 PM, Gino Pacitti wrote: > Access denied for user 'admin'@'127.0.0.1' Sounds like the root cause right there HG ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobje

Re: Help with ERXEOAccessUtilities

2011-11-14 Thread Ramsey Gurley
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.evaluateSQLWithEntity

Help with ERXEOAccessUtilities

2011-11-14 Thread Gino Pacitti
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