tags:

views:

167

answers:

0
Q: 

HQL select case

Hi

I want to do like:

select case when a.id is not null then new A(a.id) when b.id is not null then new A(null)

but it gives the error: unepected token new on line...

Any ideas?

thanks!

related questions

irritating select() behaviour in c
Best way to select out of millions of rows in an Oracle DB
Javascript to sort contents of select element
How can I create an editable dropdownlist in HTML ?
How do I do boolean logic on two columns in MySql, one of which is a Varchar?
How can I do boolean logic on two columns in MySQL?
Rows in their own columns depending on their value
SQL update from one Table to another based on a ID match
quick selection of a random row from a large table in mysql
Select columns from result set of stored procedure
Dynamically look up column names for a table while in an sql query
Java NIO select() returns without selected keys - why?
Select products where the category belongs to any category in the hierarchy
Select specific rows with SQL Server XML column type
What does "select((select(s),$|=1)[0])" do in Perl?
c# FormField DropDownList height
What is wrong with this _popen / select example?
Javascript to detect whether the dropdown of a select element is visible
Oracle Insert via Select from multiple tables where one table may not have a row
Case-insensitive search using Hibernate
Select tag's size attribute through css?
SQL Query Help: Selecting Rows That Appear A Certain Number Of Times
Select rows in dataset table based on other dataset table
Restrict selection of SELECT option without disabling the field
Select all columns except one in MySQL?