Re: EOQualifier to qualify NSTimestamp by month
Re: EOQualifier to qualify NSTimestamp by month
- Subject: Re: EOQualifier to qualify NSTimestamp by month
- From: Chuck Hill <email@hidden>
- Date: Tue, 1 Jun 2010 16:35:29 -0700
Now there is a bit of smart thinking! Make it a prototype and you
retain some measure of database independence.
Chuck
On Jun 1, 2010, at 4:20 PM, Johnny Miller wrote:
Could he follow your advice, about using SQL, and create a derived
column in his model and then use a standard qualifier against the
derived column?
On Jun 1, 2010, at 12:53 PM, Chuck Hill wrote:
On Jun 1, 2010, at 3:30 PM, Joe Kramer wrote:
Hi all,
I may be barking up the wrong tree here, but I wanted someone to
confirm that for me. I have a simple Person EO with a NSTimestamp
attribute for birthdate. I'm wondering if it is possible to
create a qualifier to get all the people whose birthday is in a
particular month (May, for example). The year doesn't matter so I
can't do a simple ">" or "<". If this isn't possible (or
efficient) I can change the data model to capture the birth month
separately. Then I can just set the month programatically when a
new person is created and use that value as the qualifier. Just
curious what others think.
Define "possible". :-P The SQL way is
select extract(MONTH from col_name) from table_name;
So you could write a custom qualifier to do this. Generally,
writing qualifiers ranks as "non trivial". I don't know of an
existing qualifier that you can use. Depending on your needs, SQL
might be the way to go. See EOSQLQualifier JavaDocs.
Chuck
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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
Johnny Miller
Kahalawai Media Corp
http://www.kahalawai.com
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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