RE: [castor-dev] Multi-column queries

Wed, 21 Sep 2005 00:58:47 -0700

Sylvie,
 
I am not 100% sure whether you can execute such a query using OQL, but I am defnitely sure that you could use the SQL CALL feature of OQL to execute that query, given that you adhere to the sequence of properties for fr.cnam.Cat as defined in your mapping file.
 
Werner
 
PS Have you tried to run it at all ?

From: SYLVIE PALLUEL [mailto:[EMAIL PROTECTED]
Sent: Mittwoch, 21. September 2005 08:12
To: [email protected]
Subject: [castor-dev] Multi-column queries

Hello,

 

I have to make statistics on the datas of our application.

 

Is it possible to use OQL to make this query (I’m still in 0.9.6): select cat.color, sum(cat.weight), count(cat)   from fr.cnam.Cat cat  group by cat.color

 

And in this case what kind of object will be the result of the execution? 

 

Thanks for your help.

 

Sylvie.

___________________

CREDI RA

Sylvie Palluel

 

[EMAIL PROTECTED]

___________________

 

 

 

Reply via email to