Custom select string for Expressions?

From: Tobias SCHOESSLER (Tobias.Schoessle..nvienna.org)
Date: Wed Mar 29 2006 - 02:09:19 EST

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

    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 : Wed Mar 29 2006 - 02:09:48 EST