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
