get total count from a subquery

nickel · **Joined:** Mon Oct 06, 2003 2:20 pm **Posts:** 10

Hi,

I want to get the total number of records of a query.
My query is like this:
"from P p where p.userID in (:userIDs) ";

the userIDs is a list of keys.

====================

i tried to do the following to get the total number of record, but it doesn't work for my case.

String request =
"select count(*) from P p where p.userID in "+ userIDs;

count = ( (Integer) ses.iterate(request).next()).intValue();

It only works if my query based on a single userID using '=userID', but not work if I use 'in userIDs'.

Thanks for the advise.

dimas · **Posted:** Thu Nov 27, 2003 4:22 pm

1. you better use .list() instead of .iterate()
2. are you sure you constructing correct query? Concatinating parameters to the query is not the best idea. You should use query.setParameterList() instead

emmanuel · **Posted:** Thu Nov 27, 2003 5:01 pm

Code:

Query q = s.createQuery("select count(*) from P p where p.userID in (:userIDs)");
// myUserIDs is a collection or an Object[]
q.setParameterList("userIDs", myUserIDs);
count = ( (Integer) q.iterate().next() ).intValue();