Hi,
I try since long time to do a sql query with a group by :
l_query = "SELECT distinct(a.dateEngagement) from
fr.cmc.umm.mapping.tache.MTacheDateEngagement a group by a.dateEngagement " ;
try {
Query oql = database.getOQLQuery(l_query);
QueryResults l_results = oql.execute();
// mappage
while (l_results.hasMoreElements()) {
.....
}
And I have the next exception :
OQLSyntaxException :
"An incorrect token type was found near group (2, need 0"
I see the doc about Advanced OQL, and don't understand the syntax :
groupClause ::= group by fieldList { havingClause}
fieldList ::= field {,field}
field ::= identifier: expr
identifier ::= letter{letter| digit| _}
...
Someone could help me ??
Thanks a lot.
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
