Thank you.
Frank
----- Original Message -----
From: "Christian Mittendorf" <christian.mittendor..reenet.de>
To: <use..ayenne.apache.org>
Sent: Thursday, February 01, 2007 7:16 PM
Subject: Re: how to call a custom query
> Please check out the documentation at the great new Cayenne homepage:
>
> http://cayenne.apache.org/doc20/queries.html
>
> ...especially the part on SQLTemplates
>
> Christian
>
> P.S. The link to the API (http://cayenne.apache.org/1_2/api/cayenne/
> org/objectstyle/cayenne/query/package-summary.html) from the 1.2
> documentation returns a 404 error....
>
>
> Am 02.02.2007 um 01:02 schrieb Frank:
>
>> 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:52:23 EST