Hi,
i'm using NHibernate 1.2.1 with oracle 8 and i'm getting a strange problem with the use of the nvl function in a named query.
Here is the query:
Code:
Select Sum(nvl(e.Value,0))
From Entity e
Where
e.Societe = :Societe And
e.Titre = :Titre And
e.SousTitre = :SousTitre And
e.Chapitre = :Chapitre And
e.Article = :Article And
e.Paragraphe = :Paragraphe And
e.SousParagraphe = :SousParagraphe And
(e.Date Between :StartDate And :EndDate)
I have a QueryException with the message "alias or expression expected".
Any ideas?
Regards.
Walid Soumer.
Login
FAQ
Search