Re: Custom select string for Expressions?

From: I. Venuti (i.venut..aribel.it)
Date: Thu Mar 30 2006 - 05:24:31 EST

  • Next message: Andrus Adamchik: "Re: Custom select string for Expressions?"

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

    This archive was generated by hypermail 2.0.0 : Thu Mar 30 2006 - 05:24:57 EST