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 protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/jlmiller%40kahalawai.com
> 
> This email sent to [email protected]

Johnny Miller
Kahalawai Media Corp
http://www.kahalawai.com



 _______________________________________________
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]

Reply via email to