Using Functions in HQL

Cassio · **Joined:** Wed Oct 17, 2007 8:41 pm **Posts:** 2

Hi,

I can register and use SQL functions in HQL, but it only works on the WHERE clause.
Why can't I use in the projection clause like this?

"SELECT dbo.MyFunction(t.Field) FROM Table t"

I don't understand this technical limitation.

Thanks in advance.

Cassio · **Joined:** Wed Oct 17, 2007 8:41 pm **Posts:** 2

Anyone please?

mnichols · **Joined:** Mon Aug 21, 2006 9:18 am **Posts:** 179

Check this post out:
[url]
http://www.ayende.com/Blog/archive/2006/10/01/7235.aspx
[/url]

I'd guess the problem you are having is because you are passing a parameter from the FROM alias.
I'd test it with a static parameter :parameter and see if it works then adjust accordingly.