Error if a null parameter is in my order by query

fmourioux · **Joined:** Mon Sep 15, 2003 9:10 am **Posts:** 43

Hi,

I like to know how can i do if a parameter is null in my "order by" query ?

My query is :

Code:

from OffreFret as o 

where  (modele=0) and  (dateFinValidite is null or dateFinValidite>:dateFinValidite)  and (o.utilisateur.id=1) 

order by o.paysEnlevement.libelle, o.departementEnlevement.libelle, o.regionEnlevement.libelle

My null parameter is the "o.departementEnlevement" object ?

It returns only rows where where departementEnlevement is not null.

Thanks again for your help !

Fabien.

stolley · **Posted:** Wed May 26, 2004 7:55 pm

Does that work in SQL? (as opposed to Hibernate HQL)

fmourioux · **Joined:** Mon Sep 15, 2003 9:10 am **Posts:** 43

I don't know is there anyone know ?

Please help !

Fabien.