Re: creating my EOQualifier in code
Re: creating my EOQualifier in code
- Subject: Re: creating my EOQualifier in code
- From: "Daniele Corti" <email@hidden>
- Date: Mon, 25 Feb 2008 13:11:51 +0100
2008/2/25, Theodore Petrosky <email@hidden>:
Now this makes no sense to me and I don't understand
what to do...
This is my method:
public WOComponent useSearchField() {
EOEditingContext ec =
session().defaultEditingContext();
if (userEntries.valueForKey("client") != null) {
//only do this if there is a value in the search field
NSMutableArray arg1 = new NSMutableArray();
arg1.addObject(userEntries.valueForKey("client"));
EOQualifier newQual =
EOQualifier.qualifierWithQualifierFormat
("(client caseInsensitiveLike %@) AND (isComplete =
0)", arg1);
EOFetchSpecification fs = new EOFetchSpecification
("AsAdSched", newQual, null);
fs.setRefreshesRefetchedObjects(true);
//NSLog.out.appendln("fetchscpec = " + fs);
fetchResult = ec.objectsWithFetchSpecification(fs);
}
return null;
}
Look, could you use EOKeyValueQualifier and EOAndQualifier?
EOKeyValueQualifier myQual = null;
NSMutableArray array = new NSMutableArray();
EOFetchSpecification fs;
myQual = new EOKeyValueQualifier("client", EOQualifier.QualifierCaseInsensitiveLike, userEntries.valueForKey("client"));
array.addObject(myQual);
myQual = new EOKeyValueQualifier("isComplete", EOQualifier.QualifierEquals, new Integer(0));
array.addObject(myQual);
fs = new EOFetchSpecification("AsAdSched", new EOAndQualifier(array), null);
fs.setRefreshesRefetchedObjects(true);
fetchResult = ec.objectsWithFetchSpecification(fs);
I wish I could find examples of some of this stuff.
Ted
------------------------------
Message: 3
Date: Sun, 24 Feb 2008 21:58:38 -0800
From: Chuck Hill <email@hidden>
Subject: Re: creating my EOQualifier in code
To: WebObjects-Dev List
<email@hidden>
Message-ID:
<email@hidden">email@hidden>
Content-Type: text/plain; charset=US-ASCII; delsp=yes;
format=flowed
And I think you need to add the *...* to the value in
arg1, not the
format.
On Feb 24, 2008, at 9:32 PM, Mike Schrag wrote:
> % is SQL syntax ... In EOQualifier syntax, you want
to use *
>
> ms
>
> On Feb 25, 2008, at 12:28 AM, Theodore Petrosky
wrote:
>
>>
>>
>> I am using the caseinsensitiveLike however I can
not
>> get the global '%' to work...
>>
>> EOQualifier newQual =
>> EOQualifier.qualifierWithQualifierFormat
>> ("(client caseInsensitiveLike %@%%) AND (isComplete
=
>> 0)", arg1);
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
--
Daniele Corti
AIM: S0CR4TE5
Messenger:
email@hidden--
Computers are like air conditioners -- they stop working properly if you open
WINDOWS
--
What about the four lusers of the apocalypse? I nominate:
"advertising", "can't log in", "power switch" and "what backup?"
--Alistair Young
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden