Thanks for your reply Werner. I tried:
"select p from Person p where p.courses.id = 1 or p.courses.id = 2" and it returns all Persons who are either Course, but I'm trying to find all Persons who are in *both* Courses. I tried using "and" instead of "or", but it didn't work unfortunately. Any ideas? Thanks. --- Werner Guttmann <[EMAIL PROTECTED]> wrote: > > Konrad, > > your query could be expressed in quite some ways, > but here's one way it could be done. > > select p from Person p where p.courses.id = 1 or > p.courses.id = 2 > > Apart from this, you could use the IN operator, but > here I have to pass on the syntax as I am not really > familiar ... 8-(. But maybe somebody else can help > ? > > I hope this helps a little bit ... > > Regards > Werner > > On Wed, 11 Feb 2004 21:29:04 -0800 (PST), Konrad > wrote: > > > > >Hello. > > > >In Castor, how would I peform an OQL query that > >queries against a certain property of a collection > of > >objects belonging to another object? > > > >For example, say I have the following classes: > > > >Person > >------ > >id > >name > >courses <- ArrayList that holds several Courses > > > >Course > >------ > >id > >name > >category > > > > > >The tables would look as follows: > > > > > >Person > >------ > >id > >name > > > > > >Person_Course > >------------- > >id > >person_id > >course_id > >comment > > > > > >Course > >------ > >id > >name > > > > > >Given this scenario, how would I find all the > Persons > >that have certain courses? > > > >For example, if I have course1(id=1) and > course2(id=2) > >are the Courses, how would I find all the People > that > >are signed up for both Courses? > > > >Is the below the proper OQL for querying certain > >attributes of the objects in the collection? > > > >select p from Person p where p.courses=(new > ArrayList > >containing course1 and course2??) > > > >Thank you very much. > > > >__________________________________ > >Do you Yahoo!? > >New Yahoo! Photos - easier uploading and sharing. > >http://photos.yahoo.com/ > > > >----------------------------------------------------------- > > >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 > __________________________________ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
