hi,
I have tried to find extensive information about constructing QBC queries and looked at http://hibernate.sourceforge.net/reference/html/ but could find nothing there on the topic. Could you point me to a resource which deals with this in great depth? What I am trying to do is this:

Note: case statement determines value of photoNum.

select photoNum from tableName where id=x;

I was using StringBuffer to build the queries before, but was advised against this by Christian.

many thanks in advance

Hibernate ver 2.1.1
Database: postgreSQL 7.4.1

Read that chapter:

http://www.theserverside.com/books/revi ... Review.jsp