how do I read group records?

From: Frank (farocc..otmail.com)
Date: Wed May 09 2007 - 21:26:02 EDT

  • Next message: Mike Kienenberger: "Re: how do I read group records?"

    Hello,

    I have a cayenne routine that returns records using an SQLTemplate.
    I return the records in a List

    sql = "SELECT COUNT(ticketId) AS cnt, userName FROM table"

    List list - query.performQuery(ticket.class, sql)
    return list

    How do I access each column in the list?
    I tried created a class with th etwo fields in the query, but that failed.

    I want to iterate through the list and assign the values of cnt and userName

    Thanks

    Frank

    This archive was generated by hypermail 2.0.0 : Wed May 09 2007 - 21:26:32 EDT