Richard Bayet wrote:
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.
Here it is.
http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]&msgId=1739554
(If direct link fails, head to http://nagoya.apache.org/eyebrowse/[EMAIL PROTECTED]&msgId=1739554
and search messages bodies for "SimpleCriteria").
You were right, subqueries aren't supported but they can be easily added.
Regards.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
