Don't know Informix details, but generally DbAdapter takes care of
that in a db-specific manner. Our Informix adapter effort got stuck
for now [1]. So I suggest to first check whether
ExpressionFactpry.likeIgnoreCaseExp() works. If it doesn't, you have
two choices - customize the adapter for Informix or use SQLTemplate.
Andrus
* [1] http://objectstyle.org/jira/browse/CAY-300
On Mar 30, 2006, at 2:24 PM, I. Venuti wrote:
> 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
This archive was generated by hypermail 2.0.0 : Thu Mar 30 2006 - 05:38:02 EST