Hi everyone,
I've got a problem with something quite "easy", and besides, already used in
another place in my application ...
The source code is :
====================
ArrayList listRole = new ArrayList();
listRole.add("Correspondant");
criteria.addJoin( SalariePeer.USER_ID, TurbineUserGroupRolePeer.USER_ID );
criteria.addJoin(TurbineRolePeer.ROLE_ID, TurbineUserGroupRolePeer.ROLE_ID);
criteria.addNotIn(TurbineRolePeer.ROLE_NAME,listRole);
criteria.setDistinct();
List lstSalarie = SalariePeer.doSelect(criteria);
====================
It gives me an sql request without any column selected :
SELECT DISTINCT FROM TURBINE_ROLE, SALARIE, TURBINE_USER_GROUP_ROLE WHERE
TURBINE_ROLE.ROLE_NAME NOT IN ('Correspondant') AND
SALARIE.USER_ID=TURBINE_USER_GROUP_ROLE.USER_ID AND
TURBINE_ROLE.ROLE_ID=TURBINE_USER_GROUP_ROLE.ROLE_ID
And an java.sql.Exception in thrown :
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for
JDBC][SQLServer]Data type like text, ntext or image cannot be selected as
DISTINCT.
(error message translated from french)
As someone got an idea ?
Thanks !
==================================
Fr�d�ric Kerneuzet
==================================
