Re: How do I return a record count?

• Previous message: Frank: "How do I return a record count?"
• In reply to: Frank: "How do I return a record count?"
• Next in thread: Frank: "Re: How do I return a record count?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

On 3/23/07, Frank <farocc..otmail.com> 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
>

• Next message: Frank: "Re: How do I return a record count?"
• Previous message: Frank: "How do I return a record count?"
• In reply to: Frank: "How do I return a record count?"
• Next in thread: Frank: "Re: How do I return a record count?"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Fri Mar 23 2007 - 11:01:40 EDT