Hibernate Community • View topic - pass in parameters to ORDER BY in HQL?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

pass in parameters to ORDER BY in HQL?

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

csc

Post subject: pass in parameters to ORDER BY in HQL?

Posted: Wed Jul 28, 2004 2:43 pm

Beginner

Joined: Thu Jul 22, 2004 8:09 am
Posts: 20

Can I have bind variables in the order by clause in HQL like

Select from Object a where a.name=? order by ?

Thanks

Top

puffybsd

Post subject: these aren't bind parameters...

Posted: Wed Jul 28, 2004 3:03 pm

Regular

Joined: Mon Sep 29, 2003 9:39 am
Posts: 67

If I understand correctly, you'd like to dynamically specify properties to sort by in your HQL.
See "14.3 Ordering Results" in the Hibernate Reference manual.
If you build your Criteria on the fly, you can specify Order objects:
...addOrder(Order.asc("name"))...
from the example. Hope that helps.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate 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