cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank" <faro...@hotmail.com>
Subject how do I read group records?
Date Thu, 10 May 2007 01:26:02 GMT
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
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message