"Between" intervals will work for some but not all such queries. E.g.
"select all contacts with birthday in March regardless of the year"
requires a way to extract month from date before matching. Cayenne
expressions will not handle that.
So I guess a creating a SQLTemplate in the Modeler is the way to go
in such cases.
Andrus
On Jun 29, 2005, at 4:33 PM, Cris Daniluk wrote:
> Why not just use an Expression and some dates?
>
> Create a date object for the beginning of 1967 and for the end of
> 1967, then do:
>
> context.performQuery(yourQuery, Expression.betweenExp("birthdate",
> beginningOfYear, endOfYear));
>
> Cris
>
> On 6/29/05, Daniel Lorimer <thelorime..mail.com> wrote:
>
>> I'm working with date queries in Java using Cayenne as the ORM and
>> MySQL as
>> the database.
>>
>> What I want to do now is allow the user to select queries based
>> only on the
>> year, month, or day.
>> For instance: all contacts born in 1967, all contacts with a
>> birthday in
>> March, etc.
>>
>> I know this can be done relatively easily in MySQL.
>>
>> My question is, is there an easy way to do this with Cayenne.
>>
>> I assume I have to build a SQLTemplate query. Is this correct?
>>
>> However, before I go building some complex query, I'd like to
>> know if
>> there's a simpler way.
>>
>> Either way, I'd appreciate some suggestions.
>>
>> Thanks so much,
>> Daniel Lorimer
>>
>>
>
>
This archive was generated by hypermail 2.0.0 : Wed Jun 29 2005 - 16:40:08 EDT