How do I return a record count?

From: Frank (farocc..otmail.com)
Date: Fri Mar 23 2007 - 10:58:34 EDT

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

    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 - 10:59:14 EDT