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:05:28 EST