Re: how do I read group records?

From: Mike Kienenberger (mkienen..mail.com)
Date: Wed May 09 2007 - 21:30:09 EDT

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

    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 <farocc..otmail.com> 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

    This archive was generated by hypermail 2.0.0 : Wed May 09 2007 - 21:30:54 EDT