Re: Custom select string for Expressions?

From: Tobias SCHOESSLER (Tobias.Schoessle..nvienna.org)
Date: Thu Mar 30 2006 - 09:17:45 EST

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

    ok, I am in for using SQLTemplate, no problem. But there must be something
    helping me create the WHERE/FROM clauses based on a given Expression.

    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

                                                                               
                 Andrus Adamchik
                 <andru..bjectsty
                 le.org> To
                                           cayenne-use..ncubator.apache.org
                 Wednesday, 29 cc
                 March 2006 19:32
                                                                       Subject
                                           Re: Custom select string for
                 Please respond to Expressions?
                 cayenne-use..ncu
                 bator.apache.org
                                                                               
                                                                               
                                                                               
                                                                               

    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 - 09:18:11 EST