My understanding is that you cannot use 'IN' in this way.
The below snippet works correctly (even with an empty ejb-ql) for me - the IN is used
to say 'the given group is IN the set referenced by the object'. You appear to be
using the SQL type-of IN.
I don't think your approach works ... but if it does, please let me know as I would
LOVE to be able to send in a Collection and check whether a value of an object was in
it!
<jboss-ql>
[CDATA[
SELECT OBJECT(o)
FROM MyEJB o, IN(o.groups) g
WHERE o.type = ?1 and g = ?2
]]
</jboss-ql>
View the original post :
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3849773#3849773
Reply to the post :
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3849773
-------------------------------------------------------
This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
Project Admins to receive an Apple iPod Mini FREE for your judgement on
who ports your project to Linux PPC the best. Sponsored by IBM.
Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
