Re: How to alternate Criteria.addGroupBy .

2003-06-05 Thread shivaken 
Hi Thomas, 

Thanks for your advice.

But, addGroupBy() accepts Field (name or FieldDescriptor).
I want use group by like below, (with mysql)
---
select DATE_FORMAT(DATE, " %Y %m %d"), count(*) from A0
group by DATE_FORMAT(DATE, " %Y %m %d")
--- 
The type of DATE is TIMESTAMP.

Is there any way ?

On Thursday 05 June 2003 18:57, Mahler Thomas wrote:
> Just have a a look at the Javadocs:
> http://db.apache.org/ojb/api/org/apache/ojb/broker/query/QueryByCriteria.ht
>m l#addOrderBy(java.lang.String)
>
> Thomas
>


-- 
-- shivaken
antshell: Ant command line front end
http://www.antshell.org


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: How to alternate Criteria.addGroupBy .

2003-06-05 Thread Mahler Thomas 
Just have a a look at the Javadocs:
http://db.apache.org/ojb/api/org/apache/ojb/broker/query/QueryByCriteria.htm
l#addOrderBy(java.lang.String)

Thomas

> -Original Message-
> From: shivaken [mailto:[EMAIL PROTECTED]
> Sent: Thursday, June 05, 2003 11:21 AM
> To: OJB Users List
> Subject: How to alternate Criteria.addGroupBy .
> 
> 
> Hi all,
> 
> Today, I noticed that Criteria.addGroupBy is deprcated. 
> Then javadoc use Query#addGroupBy .
> But, interface org.apache.ojb.broker.query.Query dosen't have 
> addGroupBy 
> method.
> 
> What do I have to use? 
> 
> -- shivaken
> antshell: Ant command line front end
> http://www.antshell.org
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]