Newbie question:

From: Chad Smith (Chad.Smit..c2Solutions.com)
Date: Sun Apr 23 2006 - 10:27:08 EDT

  • Next message: Chad Smith: "RE: 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

    This archive was generated by hypermail 2.0.0 : Sun Apr 23 2006 - 10:28:04 EDT