Nick, see my reply oon that very thread. You have to specify the fields of the SQL
statement in the same order as defined in the mapping file, otherwise
Castor will not work.
Werner
On Thu, 19 Aug 2004 18:30:17 -0400, Nick Stuart wrote:
>
>>
>>Also on another note, does pass-thru currently allow the loading of
>>sub-objects?
>Afaik, yes, as the foreign key will be resolved during instantiation.
>
>>IE a parent has a child object, can i load both the parent and
>>the child from the same pass-thru query?
>>
>
>Ok, I'm just referring to a converstion that I'm having with someone on the boards,
>and apparently the pass-thru is not working. He is writing something
like:
>SELECT p.* FROM parent AS Parent
>
>And it has a collection of child objects that is not being loaded. Do the children
>also need to get selected as well? I.e.
>SELECT p.*, c.* FROM parent OUTER JOIN child ON child.parentId = parent.id
>
>Or something like that?! Or should the first one work? My guess is that the child
>fields are in fact needed for this to work right. (just a guess though).
>
>-Nick
>
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
