article.id can't be 11 and 12 by one time: You queried follow: I = 1; (I == 1 and I == 2) this always false
So, article.id - it's one value, how one value may be and 11 and 12 ? :) -----Original Message----- From: Christoph Sturm [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 06, 2002 8:03 PM To: [EMAIL PROTECTED] Subject: [castor-dev] querying collections with oql Hello castor-dev, I have 2 classes, article and category. article contains an element called categories that represents a n:m mapping between article and category. category has a pk called id. this works: SELECT article FROM Article article where categories.id = 10 this too: SELECT article FROM Article article where categories.id = 10 or category.id = 11 but this doenst work: SELECT article FROM Article article where categories.id = 10 and category.id = 11. Is there anything i can do about it? I read somewhere about the contains keyword, but i dunno how to use it. -- Best regards, Christoph mailto:[EMAIL PROTECTED] ----------------------------------------------------------- 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