Re: how to call a custom query

From: Frank (farocc..otmail.com)
Date: Thu Feb 01 2007 - 19:02:14 EST

  • Next message: Howard Treisman: "RE: Unsubscribe"

    Can anyone help me with the a short example on how to do this?

    Thanks

    Frank
    ----- Original Message -----
    From: "Frank" <farocc..otmail.com>
    To: <use..ayenne.apache.org>
    Sent: Thursday, February 01, 2007 11:33 AM
    Subject: how to call a custom query

    > Hello,
    >
    > I have the following raw query defined.
    > SELECT BSYDTAA.BSYPEMP.EMHSP#, BSYDTAA.BSYPEMP.EMYLNM,
    > BSYDTAA.BSYPEMP.EMYFNM, BSYDTAC.BPRPPCP.PCDEP4, BSYDTAC.BPRPPCP.PCLDDS,
    > BSYDTAA.BSYPEMP.EMEMP# AS EMEMP, BSYDTAA.BSYPEMP.EMWPH# AS WPHONE FROM
    > BSYDTAA.BSYPEMP, BSYDTAC.BPRPPCP WHERE BSYDTAA.BSYPEMP.EMHSP# =
    > BSYDTAC.BPRPPCP.PCHSP# AND BSYDTAA.BSYPEMP.EMDEP4 = BSYDTAC.BPRPPCP.PCDEP4
    > AND (BSYDTAA.BSYPEMP.EMHSP# IN (1,5)) AND (BSYDTAA.BSYPEMP.EMDOT=0)
    > AND EMEMP# = ?
    >
    > How do I call this from code using the SelectQuery and passing in the
    > value?
    >
    > Thanks
    >
    > Frank
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Feb 01 2007 - 19:04:16 EST