cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "I. Venuti" <i.ven...@caribel.it>
Subject Re: Custom select string for Expressions?
Date Thu, 30 Mar 2006 10:24:31 GMT
I think that also for specify "lower( strField) like $what" I should use 
SQLTemplate, is it correct?
I'm askig becouse I use Informix as database server and I must express 
that "like" operation should be done in a case-insensitive manner...

Thanks

-- Ivan

Andrus Adamchik ha scritto:
> Hi Tobias,
>
> Unfortunately mixing expressions and aggregate syntax is not possible. 
> You'd have to use SQLTemplate.
>
> Andrus
>
>
> On Mar 29, 2006, at 11:09 AM, Tobias SCHOESSLER wrote:
>
>>
>> I like cayenne expressions a lot, instead of writing complex joins in 
>> sql
>> these path expressions are very handy. Though I haven't found a way to
>> express things I use to have in the SELECT part of an SQL statement. 
>> When I
>> need distinct values, aggregations. how can I do things like SELECT
>> DISTINCT ... SUM(), etc.
>>
>> Ideally I would like to use path Expression to define my select but 
>> apply
>> my own SELECT string for the execution. Is that possible?
>>
>> thanks
>>
>> Tobias
>>
>> ______________________________________
>> Tobias Schoessler, Java Developer
>> Information Management Unit
>> Information Technology Service
>> United Nations Office on Drugs and Crime
>>
>> Tel:  (+43-1) 26060-5173
>> Websites: www.unov.org, www.unodc.org
>> ______________________________________
>> Impossible is not a fact, only an opinion
>
>
>
> --No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.3.3/295 - Release Date: 28/03/2006
>
>

Mime
View raw message