Re: How do I return a record count?

From: Frank (farocc..otmail.com)
Date: Fri Mar 23 2007 - 11:07:13 EDT

  • Next message: Mike Kienenberger: "Re: How do I return a record count?"

    Fetch DataObjects is unchecked.
    Does this default to fetch DataRows?

    Frank

    ----- Original Message -----
    From: "Mike Kienenberger" <mkienen..mail.com>
    To: <use..ayenne.apache.org>
    Sent: Friday, March 23, 2007 11:01 AM
    Subject: Re: How do I return a record count?

    > 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
    >>
    >

    This archive was generated by hypermail 2.0.0 : Fri Mar 23 2007 - 11:07:43 EDT