Dear,
I'm currenty trying to get the following statement out of nhibernate using
criterias:
SELECT coalesce(this_.number, '') FROM TABLE this_ GROUP BY
coalesce(this_.number, '')
I have the following code:
projections.Add(Projections.GroupProperty(Projections.SqlFunction("COALESCE",
NHibernateUtil.String, Projections.Property("Number"),
Projections.Constant(string.Empty))));
The result is however quite disappointing as the result is:
SELECT
coalesce(this_.number, '')
FROM
TABLE this_
GROUP BY
coalesce(this_.batch_number, ?);
@p0 = '' [Type: String (4000)]
I've no idea where the '?' is originating from or how to solve this issue.
The NH version that is used is : 3.3.1.4000
Any help would be appreciated.
Kind regards,
Koen
P.S. The query above is part of a much larger query, but the issue is also
encountered with this easy query as well.
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/nhusers.
For more options, visit https://groups.google.com/d/optout.
