Another EJB-QL Question: distinct in a Date col

Hi all,

I am facing another issue. I have a table mapped to a CMP that has 3 cols as
PK:

PK = (DATE, UID, IID)

My final goal is to return all different dates from the table. I tried:

SELECT DISTINCT o.date FROM MyBean AS o

The problem is that I can't return a Date from a ejb-ql. i can only return a
bean. So is there a way to return beans with distinct o.date cmp field ?

thank u,
Flavio.

===========================================================================
To unsubscribe, send email to [email protected] and include in the body
of the message "signoff EJB-INTEREST".  For general help, send email to
[email protected] and include in the body of the message "help".