Thank you Bruce, With the debug approach I was trying to see what Castor was doing. (The Logger works fine thanks :)
I thought I may have been able to return some of the dependant object data with the parent data in one call, but it appears that it is not possible. I will need to query for the ID of the object that I need then make a second call for the data. Thanks Neil -----Original Message----- From: Bruce Snyder [mailto:[EMAIL PROTECTED]] Sent: 29 November 2002 17:13 To: [EMAIL PROTECTED] Subject: Re: [castor-dev] using sql call on objects will collections This one time, at band camp, Neil Blue said: NB>I am using castor 0.9.4.1, and I am able to use "SQL CALL..." to query the NB>database and return an object. But I am unable to do this for objects that NB>have collection attributes. NB> NB>Please could someone tell me the syntax required to query of such an object NB>with a collection. Neil, This may not be possible because the to-many side of the relationship is not reflected in the database from the parent side. But, on second thought, if the relationship is bi-directional at the database level, how about the following: ( "CALL SQL select * from child_object_table where child_object_table.parent_id = " + parentObject.getId() ); However, I may just be deluded. I'm working on very little sleep in the past two weeks 8-0. Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI +F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
