Forums Register Login

Equivalent of SQL "in"

+Pie Number of slices to send: Send
Hi all,

I have to locate all documents in the database for a Set of owners. Each document is defined to have a many-to-one mapping to an Owner object. Now, can I specify the owner set in the query param ?

[ June 27, 2005: Message edited by: Dushy Inguva ]
+Pie Number of slices to send: Send
Are you asking what the HQL equivalent of the SQL IN operator is? If so the answer is they are the same in both query languages, and behave in the same way. If you have an array of owner ids you can just bind that to your named parameter and there you go.
This looks like a job for .... legal tender! It says so right in this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 708 times.
Similar Threads
Returning object, based on mapping with second table?
FBNS: Final locking architecture, comment please...
HQL join syntax
This in constructor
sub query in HQL
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 19:18:44.