cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Chad Smith" <Chad.Sm...@ic2Solutions.com>
Subject Newbie question:
Date Sun, 23 Apr 2006 14:27:08 GMT
I have this syntax ...

Expression q1 = ExpressionFactory.matchExp(Company.OWNER_ID_PROPERTY,
userId);
Expression q2 = ExpressionFactory.matchExp(Company.SHARED_FLAG_PROPERTY,
"Y");
q1.orExp(q2);
select.andQualifier(q1);

I want it to produce SQL that looks like this ...

SELECT *
FROM company
WHERE (t0.owner_id = 'jsmith' OR t0.shared_flag = 'Y')

... the problem is the OR clause doesn't get appended

btw: I don't want this syntax ...

SELECT *
FROM company
WHERE (t0.owner_id = 'jsmith') OR (t0.shared_flag = 'Y')

Can someone tell me what I'm doing wrong?

Thanks in advance,

     Chad


Mime
View raw message