db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <fisc...@seitenbau.net>
Subject RE: Complexe torque crieteria
Date Mon, 14 Mar 2005 12:22:05 GMT




Please search the mailing list archives, there are several threads about
this.
Alternatively, see the criteria howto.

   Thomas
Abou Zarr <matotouraki@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


Mime
View raw message