Re: how do I read group records?

[Mike Kienenberger]

Here's an example.  Maybe it'll help.


   private Integer fetchDocumentNumberAutoIncrement() {
       String defaultSql = "SELECT #result('max(DOCUMENT_NUMBER)+1'
'long' 'ID') FROM ENG_WORK_MGMT.AUTHORIZATION_DOCUMENT";
        String oracleSql = "SELECT
#result('SEQ_AuthDocDocumentNumber.NextVal' 'long' 'ID') FROM DUAL";
        
       SQLTemplate rawSelect = new SQLTemplate(getClass(), defaultSql);
       rawSelect.setTemplate(OracleAdapter.class.getName(), oracleSql);
       rawSelect.setFetchingDataRows(true);

       List list = getDataContext().performQuery(rawSelect);
       Map row = (Map)list.get(0);

       Number autoincrementID = (Number)row.get("ID");

       return new Integer(autoincrementID.intValue());
        }



On 5/9/07, Frank <[EMAIL PROTECTED]> wrote:

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