Try adding, before you perform the query:
rawSelect.setFetchingDataRows(true);
Normally, Cayenne will want to create Java objects, but since your
Schedules class doesn't have all of the fields, you need to fetch raw
data rows. It should return a Map to you.
See if this page helps at all:
http://cwiki.apache.org/CAYDOC/data-rows.html
/dev/mrg
On 2/1/07, Frank <[EMAIL PROTECTED]> wrote:
Here is my code.
My table show no data. I have three records for this query.
I am trying to display procedure_name, provider_name, office_phone,
alt_phone
The _Schedules class does not have these fields.
What do I need to do?
Thanks
Frank
public List getRecords() {
String query = "SELECT ALL schedules.schedule_id,schedules.schedule_date,";
query += " procedures.procedure_name,providers.provider_name,";
query += " providers.office_phone,providers.alt_phone";
query += " FROM schedules";
query += " INNER JOIN procedures ON schedules.procedure_id =
procedures.procedure_id";
query += " INNER JOIN providers ON schedules.provider_id =
providers.provider_id";
query += " WHERE schedule_date = CURDATE()";
query += " ORDER BY procedure_name";
DataContext context = DataContext.getThreadDataContext();
SQLTemplate rawSelect = new SQLTemplate(Schedules.class, query);
List records = context.performQuery(rawSelect);
return records;
}
----- Original Message -----
From: "Christian Mittendorf" <[EMAIL PROTECTED]>
To: <user@cayenne.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" <[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
>>>
>>
>
>
