Re: How do I return a record count?

[Mike Kienenberger]

Did you set the query to fetch DataRows (Maps) instead of DataObjects
(Entities)?

On 3/23/07, Frank <[EMAIL PROTECTED]> wrote:

Hello,
I have a named query defined as:
SELECT COUNT(ticketId) AS cnt FROM tickets
WHERE ticketClosed = 0

This is not working, how do I get the count returned?
NamedQuery query = new NamedQuery("openTicketsQuery");
List records = context.performQuery(query).;
String cnt = records.get(0).toString();

Thanks

Frank