Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cayenne-user@incubator.apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Reply-To: <Chad.Smith@ic2Solutions.com>
From: "Chad Smith" <Chad.Smith@ic2Solutions.com>
To: <cayenne-user@incubator.apache.org>
Subject: RE: Newbie question: 
Date: Sun, 23 Apr 2006 09:54:14 -0600
Message-ID: <000701c666ee$2c045990$6501a8c0@cks>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Importance: Normal
In-Reply-To: <000201c666e2$013b1890$6501a8c0@cks>

never mind - it was an assignment problem

-----Original Message-----
From: Chad Smith [mailto:Chad.Smith@ic2Solutions.com]
Sent: Sunday, April 23, 2006 8:27 AM
To: cayenne-user@incubator.apache.org
Subject: Newbie question: 


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