You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@turbine.apache.org by Fedor Karpelevitch <fe...@Barra.COM> on 2001/11/02 16:16:34 UTC

RE: criteria hell

In this case just do not use Criteria. Why do you need to?

fedor.

-------------------------------
The Joy of CVS

> -----Original Message-----
> From: Nick Pomfret [mailto:nick.pomfret@pixelpark.com]
> Sent: Tuesday, October 30, 2001 10:02 AM
> To: Turbine Users List
> Subject: criteria hell
> 
> 
> Can someone please help me turn this SQL into a Criteria object?
> 
> select 
> 	x.id, 
> 	max(x.some_column) 
> from 
> 	table_x x,
> 	table_y y,
> where 
> 	(y.blah < x.blah 
> 	or y.blah is null )
> 	and x.id = y.id
> group by 
> 	x.id;
> 
> --
> To unsubscribe, e-mail:   
> <ma...@jakarta.apache.org>
> For additional commands, e-mail: 
> <ma...@jakarta.apache.org>
> 

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>