problem using Criteria to query null-values

[Marc Lustig <ma...@marclustig.com>]

Hi,

the following construct

Criteria c = new Criteria();
c.addJoinResellerRolePeer.RESELLER_ROLE_ID,ResellerGroupRolePeer.RESELLER_RO
LE_ID);
c.add(ResellerRolePeer.ROLE_ID,null);
c.add(ResellerGroupRolePeer.RESELLER_GROUP_ID,resellerGroupId);

results in

79044 [HttpProcessor[8080][4]] DEBUG util.BasePeer  - SELECT
RESELLER_ROLE.RESELLER_ROLE_ID, RESELLER_ROLE.NAME, RESELLER_ROLE.USER_ID,
RESELLER_ROLE.ROLE_ID FROM RESELLER_ROLE, RESELLER_GROUP_ROLE WHERE
RESELLER_GROUP_ROLE.RESELLER_GROUP_ID=1000 AND
RESELLER_ROLE.RESELLER_ROLE_ID=RESELLER_GROUP_ROLE.RESELLER_ROLE_ID

Problem: why is the condition "c.add(ResellerRolePeer.ROLE_ID,null);"
not being added?

What's wrong here?
(I want to query the field ROLE_ID for "null"-values.)

TIA.
MArc


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>