logo       

Re: Unable to create Criteria object or executeQuery: msg#00065

jakarta.turbine.torque.user

Subject: Re: Unable to create Criteria object or executeQuery

Thomas Fischer wrote:

Hi,

I do remember there was a discussion about this in the user mailing list
some time ago. The problem with your statement is that it uses subselects,
which is not (yet ???) supported in torque (contributions are welcome). One
solution was to manually create a view in the database [...]

Thomas


Well, the kind of subselect he wants to perform is not yet supported, but "classical" subselects are supported, aren't they ?
(Like "select A, B from T1, T2
where A in (select MAX(C) from T3 ...)
and ...").

But I might be wrong, I know I had to extend the Criteria class to code a "not in" operator. I got the idea from either the dev or user mailing-list.

Regards


<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise