I ran into something like this last year when I tried Postgres. My DataMap
used upper-case attribute names but Postgres uses lower-case. Andrus made a
similar suggestion -- specify every column with #result -- and it worked.
However, I didn't want to specify lots of #results so I just lower-cased all
the attribute names in my DataMap. That works too, as long as you don't
have to switch back to a different database.
----- Original Message -----
From: "Andrus Adamchik" <andru..bjectstyle.org>
To: <cayenne-use..bjectstyle.org>
Sent: Friday, May 06, 2005 1:05 PM
Subject: Re: Getting complex queries in cayenne
> Doing "select * ..." may not produce the result that Cayenne understands.
> The outcome is DB and configuration-dependent. I suggest describing each
> column in the result explicitly buy using the #result() directive (see
> docs on it at
>
http://objectstyle.org/cayenne/userguide/fetch/sqltemplate-scripting.html).
>
This archive was generated by hypermail 2.0.0 : Fri May 06 2005 - 13:44:16 EDT