Re: how to call a custom query

Frank Thu, 01 Feb 2007 19:40:46 -0800

rawSelect.setFetchingDataRows(true);<<

This seems to have resolved my issue, I can now list the missing fields.


Thanks so much.

Frank

----- Original Message -----From: "Michael Gentry" <[EMAIL PROTECTED]>

To: <user@cayenne.apache.org>
Sent: Thursday, February 01, 2007 10:04 PM
Subject: Re: how to call a custom query

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 ALLschedules.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
>>>
>>
>
>

Re: how to call a custom query

Reply via email to