db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard Bayet <rba...@club-internet.fr>
Subject Re: Unable to create Criteria object or executeQuery
Date Sat, 13 Nov 2004 11:38:18 GMT
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/ReadMsg?listName=torque-user@db.apache.org&msgId=1739554
(If direct link fails, head to 
http://nagoya.apache.org/eyebrowse/ReadMsg?listName=torque-user@db.apache.org&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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message