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
> <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:27:54 EST