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".