There is nothing that is user-friendly, but of course it would be
nice to marry the two.
SQLTemplate processing is based on a Velocity template, so it should
be theoretically possible to merge it with SQL generated by
SelectQuery translators. Can't predict how hard or easy this can be,
but look in access.jdbc and access.trans packages if you want to try
it yourself.
Andrus
On Mar 30, 2006, at 6:17 PM, Tobias SCHOESSLER wrote:
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
<[EMAIL PROTECTED]
le.org> To
cayenne-
[EMAIL PROTECTED]
Wednesday,
29 cc
March 2006 19:32
Subject
Re: Custom select string for
Please respond to Expressions?
[EMAIL PROTECTED]
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
