Re: how to call a custom query

[Christian Mittendorf]

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" <[EMAIL PROTECTED]>
To: <user@cayenne.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