Hibernate Community • View topic - Can HQL cope with vendor- functions in the select clause?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Can HQL cope with vendor- functions in the select clause?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

davidceder

Post subject: Can HQL cope with vendor- functions in the select clause?

Posted: Fri Aug 18, 2006 6:34 am

Beginner

Joined: Wed Apr 26, 2006 4:12 am
Posts: 29

Can HQL cope with this:
SELECT IsNull(m.myFld,0) as myAlias
FROM myTable m

This works without the IsNull:
SELECT m.myFld FROM myTable m

It's choking on the IsNull, saying it's not a valid mapping, but I thought that HQL could cope with these!! The IsNull works fine in a WHERE clause, though.

Top

radu

Post subject:

Posted: Fri Aug 18, 2006 7:45 pm

Senior

Joined: Wed Jun 15, 2005 4:17 am
Posts: 156

AFAIK its a limitation with HQL - it only accepts functions with one argument.

radu

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum