Re: SQL Query from EOFetchspecification

2008-03-27 Thread Art Isbell
On Mar 27, 2008, at 12:15 AM, [EMAIL PROTECTED] wrote: Could some one assist me in generating the sql query from the EOFetchSpecification object? You should be able to get there by creating an EOSQLExpressionFactory object, sending it a selectStatementForAttributes() message, and sending

Re: SQL Query from EOFetchspecification

2008-03-27 Thread John Huss
See ERXSQLHelper in Wonder I believe EOFetchSpecification spec = new EOFetchSpecification("Address", > qual, sort); > > Here I want the SQL query of the "spec" > ___ Do not post admin requests to the list. They will be ignored. Webobjects-dev ma

Re: SQL Query from EOFetchspecification

2008-03-27 Thread Alexander Spohr
Hey Rohit, 1. Don't use qualifierWithQualifierFormat, build the EOKey- and EOAndQualifier yourself. 2. Do you want the SQL as a String? Sorry, never need that, so no idea. 3. Do you want to execute the Query? Use EOEditingContexts objectsForFetchSpecification() atze Am 27.03.2008

SQL Query from EOFetchspecification

2008-03-27 Thread Rohit.Goel
Hello All, Could some one assist me in generating the sql query from the EOFetchSpecification object? For Example: NSArray arrTemp; NSMutableArray args = new NSMutableArray(); args.addObject("USA"); args.addObject("New york"); EOQualifier qual = EOQuali