Please search the mailing list archives, there are several threads about
this.
Alternatively, see the criteria howto.
Thomas
Abou Zarr <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]