Dear Hibernate Experts!!
I am having a select query to process using hibernate...The following is the syntax
"
private static final String MYQUERY = "select (if FP.fatherid=0,FP.pid,FP.msid) as msid, FP.level "+
"from Parts FP, Parts P "+
"where P.fatherid=FP.pid and P.pid=?";

List msidList = getHibernateTemplate().find(MYQUERY ,pid);

and following is the error message which I get in Tomcat
java.lang.IllegalStateException: No data type for node: org.hibernate.hql.ast.Me
thodNode
+-[METHOD_CALL] MethodNode: '('
| +-[METHOD_NAME] IdentNode: 'if' {originalText=if}
| \-[EXPR_LIST] SqlNode: 'exprList'

Please help

HKG

i think you are looking for a CASE statement.

Incorrect HQL statement.
See HQL BNF notation - http://hibernate.org/89.html

Hibernate wiki can be helpful - http://hibernate.org/37.html

Yes I am looking for a CASE Statement. But the above said query is working with MySQL
[quote="steve"]i think you are looking for a CASE statement.[/quote]

Yes, well Hibernate is not MySQL now is it?