You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-user@db.apache.org by Abou Zarr <ma...@gmail.com> on 2005/03/14 13:06:28 UTC
Complexe torque crieteria
Hi, how can i transform these query to torque
criteria?
sql = "select distinct salle "
+ "from tab1, tab2 where "
+ "((tab1.debut >= tab2 .debut "
+ "and tab1.debut < tab2 .fin) "
+ " or "
+ "(tab1.fin > tab2 .debut "
+ "and tab1.fin <= tab2 .fin)) "
+ "and tab2 .idsession = '" + session + "'";
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
RE: Complexe torque crieteria
Posted by Thomas Fischer <fi...@seitenbau.net>.
Please search the mailing list archives, there are several threads about
this.
Alternatively, see the criteria howto.
Thomas
Abou Zarr <ma...@gmail.com> schrieb am 14.03.2005 13:06:28:
> Hi, how can i transform these query to torque
> criteria?
>
> sql = "select distinct salle "
> + "from tab1, tab2 where "
> + "((tab1.debut >= tab2 .debut "
> + "and tab1.debut < tab2 .fin) "
> + " or "
> + "(tab1.fin > tab2 .debut "
> + "and tab1.fin <= tab2 .fin)) "
> + "and tab2 .idsession = '" + session + "'";
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org