Thanks Mike,
I'll try it tomorrow.
The only difference, is I need to iterate each row in the list and pull the
values.
so I am thinking I should use the Map in your example on each list.next().
regards,
Frank
----- Original Message -----
From: "Mike Kienenberger" <mkienen..mail.com>
To: <use..ayenne.apache.org>
Sent: Wednesday, May 09, 2007 9:30 PM
Subject: 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:41:40 EDT