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: <mailto:turbine-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:turbine-user-help@;jakarta.apache.org>
