Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (herse.apache.org: domain of farocco@hotmail.com designates
 65.54.246.204 as permitted sender)
Message-ID: <BAY104-DAV10A20D3E36B8FC2624E04CBA8E0@phx.gbl>
From: "Frank" <farocco@hotmail.com>
To: <user@cayenne.apache.org>
References: <45DC441B.2080800@opensource.lk>
 <9E3C8A35-34A8-41D2-BE74-91B2E20889ED@objectstyle.org>
Subject: How do I query a joined table in cayenne?
Date: Fri, 23 Feb 2007 10:49:32 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=response
Content-Transfer-Encoding: 7bit

Hello,

I cannot figure out how to query the pcldds, pcdep4 fields
What am I doing wrong?

Thanks

Frank

** Java Code Start
 DataContext context = DataContext.getThreadDataContext();
     Integer[] hspArray = {new Integer(1), new Integer(5)};
     Expression e = ExpressionFactory.inDbExp(Bsypemp.EMHSPPOUND_PK_COLUMN, 
hspArray);
        e = 
e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.EMYLNM_PROPERTY, lname
        +"%"));
        e = 
e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.EMYFNM_PROPERTY, fname
                +"%"));
       // I'm lost here e = 
e.andExp(ExpressionFactory.likeIgnoreCaseExp(Bsypemp.class.DEPARTMENTS_PROPERTY, 
pcldds
       //         +"%"));

     SelectQuery query = new SelectQuery(Bsypemp.class,e);
     List records = context.performQuery(query);
** Java Code End

Here is my first class
package stemc.cayenne.as400.auto;

/** Class _Bsypemp was generated by Cayenne.
  * It is probably a good idea to avoid changing this class manually,
  * since it may be overwritten next time code is regenerated.
  * If you need to make any customizations, please use subclass.
  */
public class _Bsypemp extends org.objectstyle.cayenne.CayenneDataObject {

    public static final String E_MEMPPOUND_PROPERTY = "eMEMPpound";
    public static final String E_MWPHPOUND_PROPERTY = "eMWPHpound";
    public static final String EMOTSH_PROPERTY = "emotsh";
    public static final String EMSCH_PROPERTY = "emsch";
    public static final String EMYFNM_PROPERTY = "emyfnm";
    public static final String EMYLNM_PROPERTY = "emylnm";
    public static final String DEPARTMENTS_PROPERTY = "departments";

    public static final String EMEMPPOUND_PK_COLUMN = "EMEMP#";
    public static final String EMHSPPOUND_PK_COLUMN = "EMHSP#";

    public void setEMEMPpound(java.math.BigDecimal eMEMPpound) {
        writeProperty("eMEMPpound", eMEMPpound);
    }
    public java.math.BigDecimal getEMEMPpound() {
        return (java.math.BigDecimal)readProperty("eMEMPpound");
    }


    public void setEMWPHpound(java.math.BigDecimal eMWPHpound) {
        writeProperty("eMWPHpound", eMWPHpound);
    }
    public java.math.BigDecimal getEMWPHpound() {
        return (java.math.BigDecimal)readProperty("eMWPHpound");
    }


    public void setEmotsh(String emotsh) {
        writeProperty("emotsh", emotsh);
    }
    public String getEmotsh() {
        return (String)readProperty("emotsh");
    }


    public void setEmsch(String emsch) {
        writeProperty("emsch", emsch);
    }
    public String getEmsch() {
        return (String)readProperty("emsch");
    }


    public void setEmyfnm(String emyfnm) {
        writeProperty("emyfnm", emyfnm);
    }
    public String getEmyfnm() {
        return (String)readProperty("emyfnm");
    }


    public void setEmylnm(String emylnm) {
        writeProperty("emylnm", emylnm);
    }
    public String getEmylnm() {
        return (String)readProperty("emylnm");
    }


    public void setDepartments(stemc.cayenne.as400.Bprppcp departments) {
        setToOneTarget("departments", departments, true);
    }

    public stemc.cayenne.as400.Bprppcp getDepartments() {
        return (stemc.cayenne.as400.Bprppcp)readProperty("departments");
    }


}


Here is my second class
package stemc.cayenne.as400.auto;

/** Class _Bprppcp was generated by Cayenne.
  * It is probably a good idea to avoid changing this class manually,
  * since it may be overwritten next time code is regenerated.
  * If you need to make any customizations, please use subclass.
  */
public class _Bprppcp extends org.objectstyle.cayenne.CayenneDataObject {

    public static final String PCDEP4_PROPERTY = "pcdep4";
    public static final String PCINA_PROPERTY = "pcina";
    public static final String PCLDDS_PROPERTY = "pcldds";
    public static final String PCSDDS_PROPERTY = "pcsdds";

    public static final String PCDEP4_PK_COLUMN = "PCDEP4";
    public static final String PCHSPPOUND_PK_COLUMN = "PCHSP#";

    public void setPcdep4(java.math.BigDecimal pcdep4) {
        writeProperty("pcdep4", pcdep4);
    }
    public java.math.BigDecimal getPcdep4() {
        return (java.math.BigDecimal)readProperty("pcdep4");
    }


    public void setPcina(String pcina) {
        writeProperty("pcina", pcina);
    }
    public String getPcina() {
        return (String)readProperty("pcina");
    }


    public void setPcldds(String pcldds) {
        writeProperty("pcldds", pcldds);
    }
    public String getPcldds() {
        return (String)readProperty("pcldds");
    }


    public void setPcsdds(String pcsdds) {
        writeProperty("pcsdds", pcsdds);
    }
    public String getPcsdds() {
        return (String)readProperty("pcsdds");
    }


}