>>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" <blacknex..mail.com>
To: <use..ayenne.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 <farocc..otmail.com> 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" <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 - 22:40:55 EST