Will do on Monday.
Thanks for the help.
Frank
On Feb 23, 2007, at 10:02 PM, Mike Kienenberger wrote:
> I don't follow what you're trying to do.
> Can you give an example of what you expect the sql to look like when
> you're done, and give some example data so I can understand what
> you're trying to do?
>
> On 2/23/07, Frank <farocc..otmail.com> wrote:
>> 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");
>> }
>>
>>
>> }
>>
>>
This archive was generated by hypermail 2.0.0 : Fri Feb 23 2007 - 23:12:44 EST